> ## 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.

# Overview

<Danger>
  **Legacy Docs:** This page describes our legacy API. It will be deprecated in
  a future version. Please use the [v2 API](/) where possible.
</Danger>

<Note>
  **Prerequisite** Before performing full text search over a table, ensure that
  it has been [indexed](/legacy/indexing/create-index) and properly
  [tuned](/documentation/performance-tuning/overview).
</Note>

`@@@` is ParadeDB's full text search operator that means "find all rows matching a full text query."
`@@@` accepts two styles of queries:

## Query String Syntax

The left-hand side of `@@@` is the **field to search against**, and the right-hand side is a **query string**.
For example, the following query returns all rows where the `description` field matches the query `shoes`.

```sql theme={null}
SELECT description, rating, category
FROM mock_items
WHERE description @@@ 'shoes';
```

Under the hood, the query string is tokenized with the same tokenizer that the field used at index creation time.

This syntax is friendly to ORMs and prepared statements. For consistency, all examples in this section use the query string syntax.

### Special Characters

The special characters `+` , `^`, `` ` ``, `:`, `{`, `}`, `"`, `[`, `]`, `(`, `)`, `<`, `>`,`~`, `!`, `\\`, `\*`, and `SPACE` must
be escaped by a `\` inside the query term.

## Query Builder Syntax

The left-hand side of `@@@` is the **[key field](/legacy/indexing/create-index#choosing-a-key-field)** and the right-hand side is
a **[query builder function or JSON object](/legacy/advanced/overview)**. This syntax is necessary for capturing more complex query types
like fuzzy matching or term-level search that cannot be expressed by query strings.

<CodeGroup>
  ```sql Function Syntax theme={null}
  SELECT description, rating, category
  FROM mock_items
  WHERE id @@@ paradedb.match('description', 'shoes');
  ```

  ```sql JSON Syntax theme={null}
  SELECT description, rating, category
  FROM mock_items
  WHERE id @@@
  '{
      "match": {
          "field": "description",
          "value": "shoes"
      }
  }'::jsonb;
  ```
</CodeGroup>