Rob, no that does not work either. Thanks for trying though.
2013/3/26 Rob Richardson <[email protected]>: > I think you need wildcards: > > SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE %T2.Terms% > > RobR, not guaranteeing correct syntax > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Gert Van Assche > Sent: Tuesday, March 26, 2013 12:53 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] looking up records with terms in a table > > 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. > > thanks > > gert > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
