note_text
-> FROM productnotes
-> WHERE Match(note_text) Against(
‘rabbit‘);
+----------------------------------------------------------------------------------------------------------------------+
| note_text
|
+----------------------------------------------------------------------------------------------------------------------+
| Customer complaint: rabbit has been able
to detect trap, food apparently less effective now.
|
| Quantity varies, sold
by the sack
load.
All guaranteed
to be bright
and orange,
and suitable
for use as rabbit bait.
|
+----------------------------------------------------------------------------------------------------------------------+
SELECT note_text
-> FROM productnotes
-> WHERE note_text
LIKE ‘%rabbit%‘;
+----------------------------------------------------------------------------------------------------------------------+
| note_text
|
+----------------------------------------------------------------------------------------------------------------------+
| Quantity varies, sold
by the sack
load.
All guaranteed
to be bright
and orange,
and suitable
for use as rabbit bait.
|
| Customer complaint: rabbit has been able
to detect trap, food apparently less effective now.
|
+----------------------------------------------------------------------------------------------------------------------+
SELECT note_text, Match(note_text) Against(
‘rabbit‘)
AS rank
-> FROM productnotes;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+
| note_text
| rank
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+
| Customer complaint:
Sticks not individually wrapped, too easy
to mistakenly detonate
all at
once.
Recommend individual wrapping. | 0 |
| Can shipped
full, refills
not available.
Need to order new can
if refill needed.
| 0 |
| Safe
is combination locked, combination
not provided
with safe.
This is rarely a problem
as safes are typically blown up
or dropped
by customers.
| 0 |
| Quantity varies, sold
by the sack
load.
All guaranteed
to be bright
and orange,
and suitable
for use as rabbit bait.
| 1.5905543565750122 |
| Included fuses are short
and have been known
to detonate too quickly
for some customers.
Longer fuses are available (item FU1) and should be recommended.
| 0 |
| Matches
not included, recommend purchase
of matches
or detonator (item DTNTR).
| 0 |
| Please note that no
returns will be accepted
if safe opened using explosives.
| 0 |
| Multiple customer
returns, anvils failing
to drop fast enough
or falling backwards
on purchaser. Recommend that customer considers using heavier anvils.
| 0 |
| Item
is extremely heavy. Designed
for dropping,
not recommended
for use with slings, ropes, pulleys,
or tightropes.
| 0 |
| Customer complaint: rabbit has been able
to detect trap, food apparently less effective now.
| 1.6408053636550903 |
| Shipped unassembled, requires common tools (including oversized hammer).
| 0 |
| Customer complaint:
Circular hole in safe
floor can apparently be easily cut
with handsaw.
| 0 |
| Customer complaint:
Not heavy enough
to generate flying stars around head
of victim.
If being purchased
for dropping, recommend ANV02
or ANV03 instead.
| 0 |
| Call
from individual trapped
in safe plummeting
to the ground, suggests an
escape hatch be added.
Comment forwarded to vendor.
| 0 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+
SELECT note_text
-> FROM productnotes
-> WHERE MATCH(note_text) Against(
‘anvils‘);
+----------------------------------------------------------------------------------------------------------------------------------------------------------+
| note_text
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------+
| Multiple customer
returns, anvils failing
to drop fast enough
or falling backwards
on purchaser. Recommend that customer considers using heavier anvils.
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------+
SELECT note_text
-> FROM productnotes
-> WHERE MATCH(note_text) AGAINST(
‘anvils‘ WITH QUERY EXPANSION);
+----------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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).
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------+
SELECT note_text
-> FROM productnotes
-> WHERE MATCH(note_text) AGAINST(
‘heavy‘ IN BOOLEAN MODE);
+---------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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.
|
+---------------------------------------------------------------------------------------------------------------------------------------------------------+
SELECT note_text
FROM productnotes
WHERE MATCH(note_text) AGAINST(
‘heavy -rope*‘ IN BOOLEAN MODE);
+---------------------------------------------------------------------------------------------------------------------------------------------------------+
| note_text
|
+---------------------------------------------------------------------------------------------------------------------------------------------------------+
| Customer complaint:
Not heavy enough
to generate flying stars around head
of victim.
If being purchased
for dropping, recommend ANV02
or ANV03 instead.
|
+---------------------------------------------------------------------------------------------------------------------------------------------------------+
SELECT note_text
-> FROM productnotes
-> WHERE MATCH(note_text) AGAINST(
‘+rabbit +bait‘ IN BOOLEAN MODE);
+----------------------------------------------------------------------------------------------------------------------+
| note_text
|
+----------------------------------------------------------------------------------------------------------------------+
| Quantity varies, sold
by the sack
load.
All guaranteed
to be bright
and orange,
and suitable
for use as rabbit bait.
|
+----------------------------------------------------------------------------------------------------------------------+
SELECT note_text
FROM productnotes
WHERE MATCH(note_text) AGAINST(
‘rabbit bait‘ IN BOOLEAN MODE);
+----------------------------------------------------------------------------------------------------------------------+
| note_text
|
+----------------------------------------------------------------------------------------------------------------------+
| Quantity varies, sold
by the sack
load.
All guaranteed
to be bright
and orange,
and suitable
for use as rabbit bait.
|
| Customer complaint: rabbit has been able
to detect trap, food apparently less effective now.
|
+----------------------------------------------------------------------------------------------------------------------+
-- 匹配短语rabbit bait而不是匹配两个词rabbit和bait
SELECT note_text
FROM productnotes
WHERE MATCH(note_text) AGAINST(
‘"rabbit bait"‘ IN BOOLEAN MODE);
+----------------------------------------------------------------------------------------------------------------------+
| note_text
|
+----------------------------------------------------------------------------------------------------------------------+
| Quantity varies, sold
by the sack
load.
All guaranteed
to be bright
and orange,
and suitable
for use as rabbit bait.
|
+----------------------------------------------------------------------------------------------------------------------+
-- 增加前者的等级，降低后者的等级
SELECT note_text
FROM productnotes
WHERE MATCH(note_text) AGAINST(
‘>rabbit <bait‘ IN BOOLEAN MODE);
+----------------------------------------------------------------------------------------------------------------------+
| note_text
|
+----------------------------------------------------------------------------------------------------------------------+
| Quantity varies, sold
by the sack
load.
All guaranteed
to be bright
and orange,
and suitable
for use as rabbit bait.
|
| Customer complaint: rabbit has been able
to detect trap, food apparently less effective now.
|
+----------------------------------------------------------------------------------------------------------------------+
-- 降低后者的等级
SELECT note_text
FROM productnotes
WHERE MATCH(note_text) AGAINST(
‘+safe +(<combination)‘ IN BOOLEAN MODE);
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| note_text
|
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| Safe
is combination locked, combination
not provided
with safe.
This is rarely a problem
as safes are typically blown up
or dropped
by customers.
|
+---------------------------------------------------------------------------------------------------------------------------------------------------+
MySQL.MATCH() AGAINST()全文本搜索
标签：
