​
Basic Usage

Finds documents containing terms that match a specific regex pattern.

SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.regex('description', '(plush|leather)');
​
field
required

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

​
pattern
required

A regex pattern string.

​
Wildcard Query

The following query finds all documents that match a wildcard pattern.

SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.regex('description', 'key.*rd');