Re: full text search in mysql
| From: | Merlin | Date: | Sun, 10 Aug 2003 19:44:23 +0000 |
| Subject: | Re: full text search in mysql | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29807@lists.php.net to get a copy of this message | ||
> As of Version 4.0.1, MySQL can also perform boolean full-text searches
I am running Mysql 3.x . This sounds like a simple task to me. Is it not
implemented in 3.x?
It does not have to be OR, NOR or anything, just AND
merlin
"Larry E . Ullman" <LarryUllman@DMCInsights.Com> schrieb im Newsbeitrag
news:ED63D76E-CB57-11D7-8CA0-000393641AFC@DMCInsights.Com...
> > I do get results for islands in greece as well. How can I specify in my
> > statement, that both words have to be present?
>
> From the MySQL manual:
> As of Version 4.0.1, MySQL can also perform boolean full-text searches
> using the IN BOOLEAN MODE modifier.
>
> mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+MySQL
> -YourSQL' IN BOOLEAN MODE);
>
> Use + to indicate required words.
>
> Larry
>