On 08/10/2012 12:48 PM, E. Timothy Uy wrote:
I recently switched a table to FTS4. Usually I query this table using the
IN operator, e.g.,
SELECT * FROM Table WHERE term IN (a,b,c)
If I want to use MATCH, is my only option
SELECT * FROM Table WHERE term MATCH 'a or b or c'
I think the above is your best option. Don't forget to use
CAPITAL letters for "OR" or it won't work.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users