Ted Rolle wrote: > On Sun, 08 Nov 2009 15:06:24 +0100 > Jean-Christophe Deschamps <j...@q-e-d.org> wrote: > >> select * from lemma where 'Whoever you love' like '%' || base || '%'; > > I first tried that with this SQL statement: > > SELECT * > FROM fm > WHERE name LIKE '%Juiian%' > AND info LIKE '%' || name || '%' > ORDER by name; > > returned 0 rows.
Did you perhaps mean 'Julian' rathen than 'Juiian' ? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
