Steve Edberg wrote: > At 11:23 PM +0800 6/30/07, Niu Kun wrote: > > To quote from > > http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html > > > "... words that are present in more than 50% of the rows are considered > common and do not match." > > 'hello' appears in both (100%) of your records above, so it will not > match. You need to insert more test data before MySQL has enough words > to compute valid relevances. > > steve >
Thank you for your advice. And again, I've got the following command. mysql> insert into test values(1,"aaa"); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(1,"aaa"); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(1,"aaa"); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(1,"aaa"); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(1,"aaa"); Query OK, 1 row affected (0.00 sec) mysql> select * from test where match(name) against("hello"); Empty set (0.00 sec) mysql> select * from test where match(name) against("hello" in boolean mode); Empty set (0.00 sec) mysql> select * from test where match(name) against("world" in boolean mode); +------+-------------+ | id | name | +------+-------------+ | 1 | hello world | +------+-------------+ 1 row in set (0.00 sec) It seems that hello can't be found. But world can be found. I wonder if mysql has restrictions on the word to be found. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]