????2??rows in set (0.00 sec)

????????MATCH()??????????????????????е??????????AGAINST()????????б?????????????????????????????????????????????????????MATCH()????--?????????????????б??

??????MySQL??????????????????????????????????????????????????????÷??????“?????”??????????“??????”?????????????????????????MySQL???????????????????????MySQL???????????????????????

??????????????????????Σ?????????MATCH()?????????????????????????????

mysql> SELECT id?? MATCH (data) AGAINST ('rock') FROM reviews;
+----+-------------------------------+
id  MATCH (data) AGAINST ('rock')
+----+-------------------------------+
1                              0
2                              0
3                1.3862514533815
+----+-------------------------------+

????3??rows in set (0.00 sec)

?????????????????????????η??????и???????????????????AGAINST?????????????IN BOOLEAN MODE???η????????????μ??????У?????????е???“single”???????“Madonna”??????

mysql> SELECT id FROM reviews WHERE MATCH (data) AGAINST ('+single -madonna' IN BOOLEAN MODE);
+----+
id
+----+
1
+----+

????1??row in set (0.00 sec)

?????????????????????????????????????????????????????????????IN BOOLEAN MODE????е?*?????????????????????μ???????????β???????к???“hot”??????

mysql> SELECT id FROM reviews WHERE MATCH (data) AGAINST ('hot*' IN BOOLEAN MODE);
+----+
id
+----+
3
2
+----+

????2??rows in set (0.00 sec)

????????????????????????????????????????AGAINST??????У????μ?????????????????????“hell”??“rocks”?е??????????

mysql> SELECT id FROM reviews WHERE MATCH (data) AGAINST ('hell rocks' IN BOOLEAN MODE);
+----+
id
+----+
1
3
+----+

????3??rows in set (0.00 sec)

???????????Щ??????????????????SELECT...LIKE???????????????????Ч?????????????????????дMySQL???????????????????????????????????