Skip to main content
Legacy Docs: This page describes our legacy API. It will be deprecated in a future version. Please use the v2 API where possible.

​
Basic Usage

Identifies documents containing a phrase followed by a term prefix. 
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_expansions
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.