Prerequisite Before performing full text search over a table, it must first be indexed.

Basic Usage

@@@ is ParadeDB’s full text search operator that means “find all rows matching a full text query.” The left-hand side of @@@ accepts the field to search against, and the right-hand side accepts the query string.

SELECT description, rating, category
FROM mock_items
WHERE description @@@ 'shoes'
LIMIT 5;

@@@ itself does not perform any ordering, offsets, limits, or scoring. These operations need to be added to the overall query with ORDER BY, OFFSET, LIMIT, and paradedb.score.

Query Language

The query string on the right-hand side of @@@ uses a mini query language that supports term, phrase, filtered, and boosted queries. It also accepts query builder functions for advanced, “Elastic DSL” style queries.