From: Kun Niu (haoniukungmail.com)
Date: Mon Jul 02 2007 - 02:23:31 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <mysqlsupportvisolve.com>:
> 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" <haoniukungmail.com>
> To: <mysqllists.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/mysql?unsub=mysqlsupportvisolve.com
> >
> >
> >
> > --
> > 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:haoniukunhotmail.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]