Re: [sqlite] Column as a substring

[Ted Rolle]

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