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.
Search WWH ::




Custom Search