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 there is a Tcl variable x containing a string. If $x
> starts with either abc or def (if $x starts with any value
> in the table) I want a TRUE value (or something
> comparable) otherwise a FALSE.
You haven't said whether you problem is writing the SQL or the Tcl or
both ... here's some SQL that will return 1 if any such link value
exists, else 0. Are you sure you don't want to know which link value
matches? What happens if more than 1 link value matches -- do you care?
sqlite> create table f (link text);
sqlite> insert into f values('abc');
sqlite> insert into f values('def');
sqlite> select * from f;
abc
def
sqlite> select exists(select 1 from f where link = substr('defend', 1,
length(link)));
1
sqlite> select exists(select 1 from f where link = substr('abcpqr', 1,
length(link)));
1
sqlite> select exists(select 1 from f where link = substr('xyzzy', 1,
length(link)));
0
sqlite>
You'll need to write the Tcl code to do that with your variable $x where
I've got 'defend' etc ... all I know about Tcl is that I don't want to
know any more about Tcl :-)
HTH,
John
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
