標(biāo)題: mysql 全文檢索不出來數(shù)據(jù)？ [打印本頁] 作者: wuxiaobo_2009 時間: 2012-06-21 10:58 標(biāo)題: mysql 全文檢索不出來數(shù)據(jù)？ 本帖最后由 wuxiaobo_2009 于 2012-06-21 11:03 編輯
我的mysql ：[root@wuxiaobo ~]# mysql --version
mysql Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (i686) using readline 5.1
full-text search ：
mysql> show variables like 'ft_min_word_len';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| ft_min_word_len | 2 |
+-----------------+-------+
mysql> select * from article;
+-----------+-----------------------+-----------------------------------------+
| articleID | title | body |
+-----------+-----------------------+-----------------------------------------+
| 1 | MySQL Tutorial well | DBMS stands for DataBase... |
| 2 | How To Use MYSQL Well | After you went through a... |
| 3 | Optimizing MYSQL | In this tutorial we will show... |
| 4 | 1001 MySQL Tricks | 1.Never run mysqld as root.2..... |
| 5 | MySQL vs. YourSQL | In the following database comparison... |
| 6 | MySQL Security | When configured properly,MySQL... |
+-----------+-----------------------+-----------------------------------------+
mysql> select * from article where match(title,body) against('database');
+-----------+---------------------+-----------------------------------------+
| articleID | title | body |
+-----------+---------------------+-----------------------------------------+
| 5 | MySQL vs. YourSQL | In the following database comparison... |
| 1 | MySQL Tutorial well | DBMS stands for DataBase... |
+-----------+---------------------+-----------------------------------------+
mysql> select * from article where match(title,body) against('well');
Empty set (0.00 sec)