Thank you for your information.
It's really helpful.:)
It seems that I'll have to dig deep into the fulltext search functionality.
2007/7/2, ViSolve DB Team <[EMAIL PROTECTED]>:
Hi,
There are some words which are drawn as "Stop words" [Words which are not
searchable in Fulltext Database]. To know the list of stopwords,
http://dev.mysql.com/tech-resources/articles/full-text-revealed.html.
"hello" is a stopword, and hence your query fails to return rows.
Thanks
ViSolve DB Team
----- Original Message -----
From: "Niu Kun" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Sunday, July 01, 2007 7:53 AM
Subject: Re: Problem about fulltext search.
> 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]
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007
> 12:19 PM
>
>
--
失业
牛坤
MSN:[EMAIL PROTECTED]
