Gert Van Assche wrote: > 2013/3/26 Clemens Ladisch <[email protected]>: >> Gert Van Assche wrote: >>> What I would like to do is look for all terms that appear in the Terms >>> table. >>> Something like this (but of course this does not work): >>> SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE (SELECT Terms FROM T2); >> >> SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE T2.Terms > > Clemens, doesn't seem to work... > > The terms are just a part of the sentence, not a full match. > Your query does find full matches.
That's how you wrote it in your original query... Just add wildcards around the terms: SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE '%' || T2.Terms || '%' Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
