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

Reply via email to