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
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'
or is there an equivalent to IN?
Much obliged.
