mysql 全文检索不出来数据？
本帖最后由 wuxiaobo_2009 于 2012-06-21 11:03 编辑我的mysql ：# mysql --version
mysqlVer 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)
这个怎么空呢？
页:
[1]