Re: [sqlite] Check for existence of substring in table

2009-02-15 Thread Ulrich Schöbel
Igor Tandetnik wrote: > "Ulrich Schöbel" > wrote in > message news:4997ddb2.9070...@bmu.office-on-the.net >> I have a very simple table 'friends' with only one column >> 'link': >> >> create table friends (link text); >> >> Lets assume there are 2 rows, 'abc' and

Re: [sqlite] Check for existence of substring in table

2009-02-15 Thread Igor Tandetnik
"Ulrich Schöbel" wrote in message news:4997ddb2.9070...@bmu.office-on-the.net > I have a very simple table 'friends' with only one column > 'link': > > create table friends (link text); > > Lets assume there are 2 rows, 'abc' and 'def'. > > Then there is a Tcl variable

Re: [sqlite] Check for existence of substring in table

2009-02-15 Thread John Machin
On 15/02/2009 9:15 PM, Ulrich Schöbel wrote: > John Machin wrote: >> all I know about Tcl is that I don't want to >> know any more about Tcl :-) > > You should want to ;-) You should want to be using Python instead of Tcl ;-) ___ sqlite-users mailing

Re: [sqlite] Check for existence of substring in table

2009-02-15 Thread Ulrich Schöbel
John Machin wrote: > On 15/02/2009 8:17 PM, Ulrich Schöbel wrote: >> Hi all, >> >> I'm stuck with my problem. Hopefully someone here can help. >> >> I have a very simple table 'friends' with only one column >> 'link': >> >> create table friends (link text); >> >> Lets assume there are 2 rows,

Re: [sqlite] Check for existence of substring in table

2009-02-15 Thread John Machin
On 15/02/2009 8:17 PM, Ulrich Schöbel wrote: > Hi all, > > I'm stuck with my problem. Hopefully someone here can help. > > I have a very simple table 'friends' with only one column > 'link': > > create table friends (link text); > > Lets assume there are 2 rows, 'abc' and 'def'. > > Then

[sqlite] Check for existence of substring in table

2009-02-15 Thread Ulrich Schöbel
Hi all, I'm stuck with my problem. Hopefully someone here can help. I have a very simple table 'friends' with only one column 'link': create table friends (link text); Lets assume there are 2 rows, 'abc' and 'def'. Then there is a Tcl variable x containing a string. If $x starts with either