Rank results with bm25()

sql

SELECT rowid, title, bm25(docs) AS rank
FROM docs
WHERE docs MATCH 'sqlite wal'
ORDER BY rank;

Explanation

bm25() is the usual relevance-ranking helper for FTS5 results.

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

Match terms by prefix.

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