SQLite3, MATCH and OR

Question

Is it valid to combine MATCH with OR?

For example,

SELECT * FROM myTable WHERE name MATCH 'andrew' OR name MATCH 'bill';

does not generate any hits, while both

SELECT * FROM myTable WHERE name MATCH 'andrew'; and

SELECT * FROM myTable WHERE name MATCH 'bill';

do give hits.

%%

Edit. The select with OR error code is 1, so it's malformed some how. The result on the second and third is 0 so they're fine. I'm not sure what's wrong.

Answer 1

http://www.sqlite.org/fts3.html#section_3

SELECT * FROM myTable WHERE name MATCH 'andrew OR bill'