确实mysql> select count(*) from test where match(name) against("beijing" in boolean mode);
+----------+
| count(*) |
+----------+
| 262144 |
+----------+
1 row in set (7.17 sec)mysql> select count(*) from test where name like '%beijing%';
+----------+
| count(*) |
+----------+
| 262144 |
+----------+
1 row in set (0.25 sec)mysql> select count(*) from test where name like '%beijing%';
+----------+
| count(*) |
+----------+
| 262144 |
+----------+
1 row in set (0.25 sec)mysql> select count(*) from test where match(name) against("baaaei" in boolean mode);
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
+----------+
| count(*) |
+----------+
| 262144 |
+----------+
1 row in set (7.17 sec)mysql> select count(*) from test where name like '%beijing%';
+----------+
| count(*) |
+----------+
| 262144 |
+----------+
1 row in set (0.25 sec)mysql> select count(*) from test where name like '%beijing%';
+----------+
| count(*) |
+----------+
| 262144 |
+----------+
1 row in set (0.25 sec)mysql> select count(*) from test where match(name) against("baaaei" in boolean mode);
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货