sqlite-users  

Re: [sqlite] FTS3 Question

Petite Abeille
Sat, 17 May 2008 00:55:56 -0700

On May 17, 2008, at 9:49 AM, Mike Marshall wrote:

> SELECT guid FROM data WHERE text MATCH SELECT query FROM category

Perhaps something along these lines:

select  data.guid
from    data
join    category on category.guid = data.guid
where   data.text match category.query

Or something :)

--
PA.
http://alt.textdrive.com/nanoki/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users