Re: [sqlite] MATCH multiple

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

[sqlite] MATCH multiple

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. Respectfully