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