Search with MATCH

sql

SELECT rowid, title FROM docs WHERE docs MATCH 'sqlite';

Explanation

MATCH is the core FTS operator.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Search, rank, and highlight

Search for words appearing together in order.

Open In sheetsqlsame section

Match terms by prefix.

Open In sheetsqlsame section

Sort by relevance score.

Open In sheetsqlsame section

Decorate matched terms in search output.

Open In sheetsqlsame section

Store searchable text in an FTS5 index.

Open In sheetsql2 tag match

Add rows to an FTS5 table.

Open In sheetsql2 tag match