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
y Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Visolve DB Team [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 12, 2006 4:55 AM
> To: C.R.Vegelin; mysql@lists.mysql.com
> Subje
;[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
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" <[