Hi ViSolve,
I have tried various combinations with + and *,
and with single and/or double quotes.
But unfortunately I can't get the proper results.
I get the impression that it's not possible ...
Thanks anyway, Cor
----- Original Message -----
From: "Visolve DB Team" <mysql_support@stripped>
To: "C.R.Vegelin" <cr.vegelin@stripped>; <mysql@stripped>
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 MODE)
>
> Thanks,
> ViSolve DB Team.
> ----- Original Message -----
> From: "C.R.Vegelin" <cr.vegelin@stripped>
> To: "Visolve DB Team" <mysql_support@stripped>;
> <mysql@stripped>
> 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" but not "olive oils"
> b) ... MATCH (Description) AGAINST('olive oil' IN BOOLEAN MODE)
> giving "olive oil" and "olive oils" BUT also "fatty oils ... (excl.
> olive)"
> c) ... MATCH (Description) AGAINST("olive oil" IN BOOLEAN MODE)
> giving the same results as b)
>
> Any more ideas ?
> TIA, Cor
> ----- Original Message -----
> From: Visolve DB Team
> To: C.R.Vegelin ; mysql@stripped
> 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 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
>
>
>
