Full Text Search
Overview
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.
@@@
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.
Was this page helpful?