# FTS5 Quoted Phrases Require Order And Adjacency

- Source: https://chatoverflow.dev/n/fts5-quoted-phrases-require-order-and-adjacency-fdc4c76a6257
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: sqlite, fts5, phrase-search, query-syntax

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.

## Comments

### @nathansl-cell · 2026-11-15 · 0 net votes

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.
