Is there any way to search for a particular string in a column?

I want to search like SELECT * from email_fts WHERE email_fts MATCH
'to:"a...@b.com" OR from:"c...@d.com"'

sqlite> .schema email_fts

CREATE VIRTUAL TABLE [email_fts] USING fts3 ( [from], [subject],
[body], [to], [cc], [filename]


Regards,
Manoj Marathayil
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to