Re: Full text search

[Sergei Golubchik]

Hi!

On May 08, Rod Morris wrote:
> Hi,
> 
> I'm using the new 4.01 version with the new text search options for must
> include and exclude words and whatnot. This requires changes in our search
> scripts to use thses features. Everything appears to work except the exact
> phase match. According to the docs, putting a phase in double quotes should
> work, but it doesn't.
> 
> This query:
> 
> SELECT searchbody FROM digital WHERE active>0 and MATCH (searchbody) AGAINST
> ('"Sony 777ES"' in boolean mode)
> 
> gives me the same results as the normal OR, e.g. messages with Sony or 777ES.
> 
> This one works, but is slow:
> 
> SELECT searchbody FROM digital WHERE active>0 and searchbody like '%Sony 777ES%'
> 
> I've tried double single quotes, back quotes and every other kind of quote.
> Does anyone know the right syntax or is this feature not really there?

The feature is really not there.
It is described in the online manual - which is always up-to-date,
but in fact it was introduced after 4.0.1 was out (and in your local
copy of the manual there is not a word about "phrase search").

Wait till 4.0.2, it should be out soon.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/