On Mar 26, 2013, at 10:36 PM, "Paul Mathieu" <[email protected]> wrote:
> SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE
> CONCAT('%',T2.Terms,'%')
Alternatively, use FTS [1]:
sqlite> create virtual table sentence using fts4( content text );
sqlite> insert into sentence values( 'FTS3 and FTS4 are nearly identical' );
sqlite> create table term( content text );
sqlite> insert into term values( 'nearly' );
sqlite> select * from sentence join term on sentence.content match
term.content;
FTS3 and FTS4 are nearly identical|nearly
[1] http://www.sqlite.org/fts3.html
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
