|||
operator and means “find all documents that contain one or more of the terms tokenized from this text input.”
To understand what this looks like in practice, let’s consider the following query:
|||
operator does:
description
column. In this example,
let’s assume description
uses the default tokenizer, which splits on whitespace
and punctuation.running shoes
becomes two tokens: running
and shoes
.description
contains any one of the tokens, running
or shoes
.running
or shoes
tokens in description
.
running shoes
.
Original Text | Tokens | Match | Reason | Related |
---|---|---|---|---|
Sleek running shoes | sleek running shoes | ✅ | Contains both running and shoes . | |
Running shoes sleek | sleek running shoes | ✅ | Contains both running and shoes . | Phrase |
SLeeK RUNNING ShOeS | sleek running shoes | ✅ | Contains both running and shoes . | Lowercasing |
Sleek run shoe | sleek run shoe | ❌ | Contains neither running nor shoes . | Stemming |
Sleke ruining shoez | sleke ruining shoez | ❌ | Contains neither running nor shoes . | Fuzzy match |
White jogging shoes | white jogging shoes | ✅ | Contains shoes . | Match conjunction |
running
and shoes
. This is where the &&&
match conjunction operator comes in.
&&&
means “find all documents that contain all terms tokenized from this text input.”
White jogging shoes
and Generic shoes
are no longer returned because they do not have the token running
.
running shoes
.
Original Text | Tokens | Match | Reason | Related |
---|---|---|---|---|
Sleek running shoes | sleek running shoes | ✅ | Contains both running and shoes . | |
Running shoes sleek | sleek running shoes | ✅ | Contains both running and shoes . | Phrase |
SLeeK RUNNING ShOeS | sleek running shoes | ✅ | Contains both running and shoes . | Lowercasing |
Sleek run shoe | sleek run shoe | ❌ | Does not contain both running and shoes . | Stemming |
Sleke ruining shoez | sleke ruining shoez | ❌ | Does not contain both running and shoes . | Fuzzy match |
White jogging shoes | white jogging shoes | ❌ | Does not contain both running and shoes . | Match conjunction |
v2
. Please continue to use v1
for this capability.