Re: boolean search on phrase*

[Visolve DB Team]

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