Hi Dan, I did not know that. What was the reason that it did not work before 3.30?
Regards, Hartwig > Am 2019-10-31 um 19:16 schrieb Dan Kennedy <danielk1...@gmail.com>: > > > On 1/11/62 00:32, mailing lists wrote: >> 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. > > As of 3.30.0, should work with FTS5. > > Dan. > > >> >> Regards, >> Hartwig >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users