SQLite Forum

FTS5 tables, = vs. MATCH, index 0, and "error: no such column"
Login
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.