Database Reference
In-Depth Information
Here are some more examples to demonstrate the use of some of these
operators:
▼
Input
SELECT note_text
FROM productnotes
WHERE Match(note_text) Against('+rabbit +bait' IN BOOLEAN MODE);
▼
Analysis
This search matches rows that contain both the words
rabbit
and
bait
.
▼
Input
SELECT note_text
FROM productnotes
WHERE Match(note_text) Against('rabbit bait' IN BOOLEAN MODE);
▼
Analysis
Without operators specified, this search matches rows that contain at least one
of
rabbit
or
bait
.
▼
Input
SELECT note_text
FROM productnotes
WHERE Match(note_text) Against('"rabbit bait"' IN BOOLEAN MODE);
▼
Analysis
This search matches the phrase
rabbit bait
instead of the two words
rabbit
and
bait
.
▼
Input
SELECT note_text
FROM productnotes
WHERE Match(note_text) Against('>rabbit <carrot' IN BOOLEAN MODE);
▼
Analysis
Match both
rabbit
and
carrot
, increasing the rank of the former and
decreasing the rank of the latter.