ns" <[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2006 2:58 PM
Subject: Re: boolean search on phrase
Hello:
I may be going out on a limb, as I missed part of the thread;
nevertheless, have you tried regular expressions?
As
ng quotes.
>
> Thanks
> ViSolve DB Team.
>
> - Original Message -
> From: "C.R.Vegelin" <[EMAIL PROTECTED]>
> To:
> Sent: Thursday, October 12, 2006 2:42 PM
> Subject: boolean search on phrase*
>
>
> Hi All,
>
> I want a bool
;[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>;
Sent: Thursday, October 12, 2006 11:05 AM
Subject: Re: boolean search on phrase*
Hi,
Try with + and * fulltext boolean operators.
For instance,
MATCH (Description) AGAINST('+olive oil*' IN BOOLEAN MO
ED]>;
Sent: Thursday, October 12, 2006 4:08 PM
Subject: Re: boolean search on phrase*
Thanks ViSolve,
So far I have tried the next alternatives, not giving me what I need:
a) ... MATCH (Description) AGAINST('"olive oil"' IN BOOLEAN MODE)
giving only "olive oil"
rom: Visolve DB Team
To: C.R.Vegelin ; mysql@lists.mysql.com
Sent: Thursday, October 12, 2006 9:54 AM
Subject: Re: boolean search on phrase*
Hi
The Boolen Search will itself satisfy your query. If you enclose the phrase
within double quote ('"'), then the characters
m: "C.R.Vegelin" <[EMAIL PROTECTED]>
To:
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 foll
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
