Re: boolean search on phrase*

[Visolve DB Team]

Hi

The Boolen Search will itself satisfy your query. If you enclose the phrase within double
quote ('"'), then the characters matches only rows that contain the phrase literally, as
it was typed.

Try removing quotes.

Thanks
ViSolve DB Team.

----- Original Message ----- 
From: "C.R.Vegelin" <cr.vegelin@stripped>
To: <mysql@stripped>
Sent: Thursday, October 12, 2006 2:42 PM
Subject: boolean search on phrase*


Hi All,

I want a boolean search on a phrase.
For example on "olive oil", but it should return also "olive oils" etc.
Now I use the following:
SELECT Description FROM products
WHERE MATCH (Description ) AGAINST('"olive oil"' IN BOOLEAN MODE);
This works fine, but it does NOT return rows with "olive oils".
I tried the following:
... MATCH (Description ) AGAINST('"olive oil*"' IN BOOLEAN MODE);
but that doesn't work.
Any idea will be appreciated.

TIA, Cor