For normal tables I can use something like: SELECT * FROM Names WHERE FirstNames=? AND or OR LastName=?;
For FTS tables I can only use SELECT * FROM FTSNames WHERE FirstNames MATCH ? OR LastName MATCH ?; AND is not supported (still do not know why) Is there any possibility to use prepared statements for FTS tables with an AND condition? I like to prevent code injection. Regards, Hartwig _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users