FTS5

say it: “EF-TEE-ESS-FYVE” /ˌɛfˌtiˌɛsˈfaɪv/

SQLite's full-text search extension.

What is FTS5?

FTS5 is SQLite's full-text search extension, adding fast word search to a virtual table.

CREATE VIRTUAL TABLE notes USING fts5(title, body);
SELECT title FROM notes WHERE notes MATCH 'chocolate';

Level: Freelancer · More SQLite terms at this level

Updated