??MySQL?л?????????????
???????????? ???????[ 2012/11/13 11:45:42 ] ????????
????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???????????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11