> On Aug 30, 2019, at 12:43 AM, mailing lists <mailingli...@skywind.eu> wrote: > > SELECT * FROM myData WHERE (content MATCH 'one') AND (body MATCH 'two'); > > What is the reason that the above query is not allowed
I'm curious too. This limitation is documented somewhere, but not the reason why. For programs that generate queries automatically or by translating a different input form, it's annoying to work around. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users