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.
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.