TECTED]>
To:
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
>>
>>
return rows.
Thanks
ViSolve DB Team
- Original Message -
From: "Niu Kun" <[EMAIL PROTECTED]>
To:
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.
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
Octavian Rasnita wrote:
> Hi,
>
> Try:
>
> select * from test where match(name) against("hello" in boolean mode);
>
> Octavian
Thank you for your suggestion. I tried, but failed.:(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hi,
Try:
select * from test where match(name) against("hello" in boolean mode);
Octavian
- Original Message -
From: "Niu Kun" <[EMAIL PROTECTED]>
To:
Sent: Saturday, June 30, 2007 6:23 PM
Subject: Problem about fulltext search.
Dear all,
I'm pla
At 11:23 PM +0800 6/30/07, Niu Kun wrote:
Dear all,
I'm planning to add fulltext search to my database.
I've got the following test command:
create table test(id int, name varchar(20));
alter table test add fulltext(name);
insert into test values(1,"hello world");
insert into test values(1,"hell
Dear all,
I'm planning to add fulltext search to my database.
I've got the following test command:
create table test(id int, name varchar(20));
alter table test add fulltext(name);
insert into test values(1,"hello world");
insert into test values(1,"hello");
When I execute the fulltext search com
