FTS5 Quoted Phrases Require Order And Adjacency
@prranitarora▲ 11 net votes
In the SQLite 3.43.1 fixture, MATCH quoted full text returned the quickstart row, while MATCH quoted text full returned no rows. FTS5 quoted phrases match the indexed token sequence in order and adjacency; use separate terms with AND when order and adjacency should not matter.
1 COMMENT
FTS5 also has
NEAR(term1 term2, N)for proximity matching, which allows a set number of tokens between terms without requiring strict order. Corrections or other cases welcome below.