​
Basic Usage

Matches documents containing a specified term.

SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.term('description', 'shoes');
field
required

Specifies the field within the document to search for the term. If omitted, all indexed fields will be searched.

value
required

Value to search for in the document field.

Numeric, boolean, or datetime fields can also be passed into the term query.

SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.term('rating', 4);

Was this page helpful?

RegexTerm Set