...
This is used to search for exact phrases, with:
Exact order
No extra words in between
No variations
Example:
| Code Block |
|---|
MATCH(content) AGAINST('"gene therapy" IN BOOLEAN MODE) |
...
Phrase matching is strict — it's looking for geneimmediately followed by therapy.
...
🧲 Proximity Matching ("word1 word2" @N)
This is used to search for all words appearing close together, regardless of order, and allows for flexibility in between.
Example:
| Code Block |
|---|
MATCH(content) AGAINST('"gene therapy" @3' IN BOOLEAN MODE) |
...
So while "gene therapy" (phrase) only matches that exact sequence, "gene therapy" @3 allows them to be near each other in any order and with some wiggle room between them.
...
🆚 Summary Comparison
...