I have such table:
CREATE VIRTUAL TABLE t USING FTS3(hidden, text1, text2)
I would like user to be able to searh over 'text1' and 'text2' columns, so the query is
SELECT docid FROM t WHERE t MATCH ?
And possible requests are:
SELECT docid FROM t WHERE t MATCH 'foo'
SELECT docid FROM t WHERE t MATCH 'text1:foo OR text2:bar'
Q: how can I exclude 'hidden' column from search, so that user can't find rows by hidden value?
I am going to use 'hidden' column to refer to rows in secondary table with additional information.