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

# Phrase

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

Searches for the presence of a phrase.
For more granular controls, see the [phrase query](/legacy/advanced/phrase/phrase).

## Basic Usage

Phrases must be wrapped inside double quotes. The following query finds all documents with the word `plastic` followed immediately by `keyboard`.

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

Under the hood, the query string is first tokenized in the same way as the field was at index time. Then, a phrase query is executed with the tokenized
values.

## Slop Operator

The `~` slop operator allows for other words to come in between words in the query phrase. For instance, the following query finds documents containing
the word `ergonomic` followed by `keyboard`, allowing for a maximum of one word in between.

```sql theme={null}
SELECT description, rating, category
FROM mock_items
WHERE description @@@ '"ergonomic keyboard"~1';
```

## Phrase Prefix

The `*` prefix operator allows for the last term in the phrase query to be the prefix of another word. For instance,
`"plastic keyb"*` matches `plastic keyboard`.

```sql theme={null}
SELECT description, rating, category
FROM mock_items
WHERE description @@@ '"plastic keyb"*';
```