List:General Discussion« Previous MessageNext Message »
From:C.R.Vegelin Date:October 12 2006 9:12am
Subject:boolean search on phrase*
View as plain text  
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



Thread
boolean search on phrase*C.R.Vegelin12 Oct
  • Re: boolean search on phrase*Visolve DB Team12 Oct
    • RE: Boolean search on phrase*Jerry Schwartz12 Oct
  • Re: boolean search on phrase*C.R.Vegelin12 Oct
  • Re: boolean search on phrase*Visolve DB Team12 Oct
  • Re: boolean search on phrase*C.R.Vegelin12 Oct
  • Re: boolean search on phrase*C.R.Vegelin14 Oct