Run a phrase search

sql

SELECT rowid, title FROM docs WHERE docs MATCH '"write ahead logging"';

Explanation

Phrase queries are useful for documentation and knowledge-base search.

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

Find rows containing a term.

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 sheetsql1 tag match

Add rows to an FTS5 table.

Open In sheetsql1 tag match