Database Reference
In-Depth Information
▼
Output
+---------------------------------------------------------------------------+
| note_text |
+---------------------------------------------------------------------------+
| Multiple customer returns, anvils failing to drop fast enough or falling |
| backwards on purchaser. Recommend that customer considers using heavier |
| anvils. |
| Customer complaint: Sticks not individually wrapped, too easy to |
| mistakenly detonate all at once. Recommend individual wrapping. |
| Customer complaint: Not heavy enough to generate flying stars around head |
| of victim. If being purchased for dropping, recommend ANV02 or ANV03 |
| instead. |
| Please note that no returns will be accepted if safe opened using |
| explosives. |
| Customer complaint: rabbit has been able to detect trap, food apparently |
| less effective now. |
| Customer complaint: Circular hole in safe floor can apparently be easily |
| cut with handsaw. |
| Matches not included, recommend purchase of matches or detonator (item |
| DTNTR). |
+---------------------------------------------------------------------------+
▼
Analysis
This time seven rows were returned. The first contains the word
anvils
and is thus ranked highest. The second row has nothing to do with
anvils
,
but as it contains two words that are also in the first row (
customer
and
recommend
) it was retrieved, too. The third row also contains those same
two words, but they are further into the text and further apart, and so it was
included, but ranked third. And this third row does indeed refer to anvils (by
their product name).
As you can see, query expansion greatly increases the number of rows returned,
but in doing so also increases the number of returns that you might not act-
ually want.
Tip
The More Rows the Better The more rows in your table (and the more text within
those rows), the better the results returned when using query expansion.
MariaDB supports an additional form of full-text searching called
boolean mode
.
In boolean mode you may provide specifics as to
