Database Reference
In-Depth Information
Words to be matched
■
Words to be excluded (if a row contained this word it would not be
returned, even though other specified words were matched)
■
Ranking hints (specifying which words are more important than others
so they can be ranked higher)
■
Expression grouping
■
And more
■
Tip
Useable Even Without a
FULLTEXT
Index Boolean mode differs from the full-text
search syntax used thus far in that it may be used even if no
FULLTEXT
index is
defined. However, this would be a slow operation (and the performance would degrade
further as data volume increased).
To demonstrate what
IN BOOLEAN MODE
does, here is a simple example:
▼
Input
SELECT note_text
FROM productnotes
WHERE Match(note_text) Against('heavy' IN BOOLEAN MODE);
▼
Output
+---------------------------------------------------------------------------+
| note_text |
+---------------------------------------------------------------------------+
| Item is extremely heavy. Designed for dropping, not recommended for use |
| with slings, ropes, pulleys, or tightropes. |
| Customer complaint: Not heavy enough to generate flying stars around head |
| of victim. If being purchased for dropping, recommend ANV02 or ANV03 |
| instead. |
+---------------------------------------------------------------------------+
▼
Analysis
This full-text search retrieves all rows containing the word
heavy
(there are
two of them). The keywords
IN BOOLEAN MODE
are specified, but no boolean
operators are actually specified and so the results are just as if boolean mode had
not been specified.
