SQLite fts3: finding a row in a column

Question

Is there a way to find a specific row in a column?

I want to search as SELECT * from email_fts WHERE email_fts MATCH 'to: " [e-mail] " OR from: " [e-mail] "

Thanks in advance,

Manozh

Answer 1

Make sure you create the correct FTS columns in the FTS index:

CREATE VIRTUAL TABLE email_fts USING fts3(subject, body, "to", "from"); 

And then you can search for individual FTS columns:

 SELECT rowid FROM email_fts WHERE "to" MATCH ' [e-mail] ' UNION SELECT rowid FROM email_fts WHERE "from" MATCH ' [e-mail] ' 

EDIT: my previous answer had OR in a WHERE . Apparently sqlite does not support combining OR queries with MATCH conditions. The above union works.

The FTS docs are here; this is one example used in the docs.

http://sqlite.org/fts3.html