Keyword (BM25) search
infino_keyword_searchFind exact matches for literal terms such as identifiers, error codes, or product names using BM25 full-text search. Ranks results by relevance score, ideal for known terms over SQL LIKE.
Instructions
Use when the query is literal terms — identifiers, error codes, product names, exact phrases — and you want results ranked by relevance. BM25 full-text search over a text column: ranks rows by how well the query's tokens (and their stems) match, each with a relevance score. Matches exact tokens, not synonyms or paraphrases. Prefer this over SQL LIKE for known literal terms. For meaning-based search use infino_semantic_search; for both at once use infino_hybrid_search.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| k | No | Maximum results to return. | |
| query | Yes | Query terms, matched as literal tokens. | |
| table | Yes | Table to search. | |
| column | No | Text column to search; inferred from the table schema when omitted. | |
| columns | No | Columns to return with each hit (e.g. an id, path, or line range to cite). Defaults to the searched column; '_id' and 'score' are always included. |