Create an FTS5 virtual table

sql

CREATE VIRTUAL TABLE docs USING fts5(title, body);

Explanation

FTS5 is the go-to SQLite feature for efficient full-text 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 Create FTS5 tables

Add rows to an FTS5 table.

Open In sheetsqlsame section

Separate storage from the FTS index when needed.

Open In sheetsqlsame section

Find rows containing a term.

Open In sheetsql2 tag match

Search for words appearing together in order.

Open In sheetsql1 tag match

Match terms by prefix.

Open In sheetsql1 tag match

Sort by relevance score.

Open In sheetsql1 tag match