Overview

​

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.