SQLite Forum

(Deleted)
Login

(1.1) By David Stein (sfsdfd) on 2020-10-10 14:02:07 edited from 1.0 [source]

Deleted

(2) By Dan Kennedy (dan) on 2020-10-10 14:15:24 in reply to 1.0 [link] [source]

The "=" and MATCH operators are only equivalent if the LHS of the expression is the table name, not a column name, as it is in the examples.

The janky query syntax is documented here:

https://sqlite.org/fts5.html#full_text_query_syntax

Dan.