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.
Second, substituting OR for AND:
SELECT *
FROM fm
WHERE name LIKE '%Juiian%'
OR info LIKE '%' || name || '%'
ORDER by name;
returned 220 rows.
Third, my oriiginal inquiry:
SELECT *
FROM fm
WHERE name LIKE '%Juiian%'
OR info LIKE '%Julian%'
ORDER by name;
returned the (correct) 6 rows.
What am I missing? I'd really like for the second example to work like
the third.
Ted
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
