why this full-text search doenst work properly?# Database - 数据库
L*r
1 楼
there is a sentence "┬╗ Site Searches and Difficult " in a text field, but
when I use full-text search to search, it cant return the right result. why?
mysql> SELECT id,data FROM reviews WHERE MATCH (data) AGAINST ('difficult')&
& ma
tch(data) against ('and');
Empty set (0.00 sec)
mysql> SELECT id,data FROM reviews WHERE MATCH (data) AGAINST ('Difficult ')
&& m
atch(data) against ('and');
Empty set (0.00 sec)
mysql> SELECT id,data FROM reviews WHERE id=5039010;
+---------+-----------------------
when I use full-text search to search, it cant return the right result. why?
mysql> SELECT id,data FROM reviews WHERE MATCH (data) AGAINST ('difficult')&
& ma
tch(data) against ('and');
Empty set (0.00 sec)
mysql> SELECT id,data FROM reviews WHERE MATCH (data) AGAINST ('Difficult ')
&& m
atch(data) against ('and');
Empty set (0.00 sec)
mysql> SELECT id,data FROM reviews WHERE id=5039010;
+---------+-----------------------