Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.paradedb.com/llms.txt

Use this file to discover all available pages before exploring further.

In addition to basic match, phrase, and term queries, additional advanced query types are exposed as query builder functions. Query builder functions use the @@@ operator. @@@ takes a column on the left-hand side and a query builder function on the right-hand side. It means “find all rows where the column matches the given query.” For example: 
SELECT description, rating, category
FROM mock_items
WHERE description @@@ pdb.regex('key.*rd');
Expected Response
       description        | rating |  category
--------------------------+--------+-------------
 Ergonomic metal keyboard |      4 | Electronics
 Plastic Keyboard         |      4 | Electronics
(2 rows)
This uses the regex builder function to match all rows where description matches the regex expression key.*rd.