Based on my experience, that wouldn't quite work. You'd need to preface each
word with a plus sign:
+olive +oil*
and it would return records regardless of the order in which the two words
appear, nor how far apart they are. That might be desirable, or it might
not.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -----Original Message-----
> From: Visolve DB Team [mailto:mysql_support@stripped]
> Sent: Thursday, October 12, 2006 4:55 AM
> To: C.R.Vegelin; mysql@stripped
> 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 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
>
>
