Jean-Christophe Deschamps wrote:
>
>
> Try ... LIKE !
> select * from lemma where 'Whoever you love' like '%' || base || '%';
> If a row contains base = 'Eve' it should turn up (just an example).
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
The problem is that this query receives all data from the table. I don't
know why.
p.s. data is in cp1251
--
View this message in context:
http://old.nabble.com/Column-as-a-substring-tp26253867p26255351.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
