Run a prefix search

sql

SELECT rowid, title FROM docs WHERE docs MATCH 'concurr*';

Explanation

Useful for search-as-you-type and partial matching.

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

Search for words appearing together in order.

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