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

Reply via email to