​
Basic Usage

Matches documents containing a specified term. It is matched directly against terms in the index.

A term is treated as a token and is not tokenized further. This means that a document will not match unless one of its tokens is an exact match for the term provided in value.

SELECT * FROM search_idx.search(
	query => paradedb.term(field => 'description', value => 'shoes')
);

SELECT * FROM search_idx.search(
  query => paradedb.term(
    field => 'created_at',
    value => TIMESTAMP '2023-05-01 09:12:34'
  )
);
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.

Was this page helpful?

RegexTerm Set