​
Basic Usage

Identifies documents containing a phrase followed by a term prefix. The field must be indexed with a record of position.

SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.phrase_prefix('description', ARRAY['running', 'sh']);
field
required

Specifies the field within the document to search for the term.

phrases
required

An ARRAY of words that the search is looking to match, followed by a term prefix rather than a complete term.

max_expansion

Limits the number of term variations that the prefix can expand to during the search. This helps in controlling the breadth of the search by setting a cap on how many different terms the prefix can match.

Was this page helpful?

PhraseOverview