How to FTS-match from 2 different columns

Question

I am trying to search 2 separate columns called keyword and keyword2 for a match. Can this be done with SQLite FTS?

I've tried this statement but it did not work:

String sql = "Select * from tblvHAL2001 WHERE tblvHAL2001 MATCH 'keyword:" + question + "' OR MATCH 'keyword2:" + question +"'";

Answer 1

You should use only a single FTS query per table. FTS does have boolean operators:

... WHERE tblvHAL2001 MATCH 'keyword: "blah" OR keyword2: "blah"'

And in FTS5, a single column filter can specify multiple columns:

... WHERE tblvHAL2001 MATCH '{keyword keyword2}: "blah"'

Answer 2

WHERE tblvHAL2001 MATCH '{keyword keyword2}: "blah"'