Nice!!!!
2013/3/26 Petite Abeille <petite.abei...@gmail.com>:
>
> On Mar 26, 2013, at 10:36 PM, "Paul Mathieu" <pmath...@intellimed.com> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
