| 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.Vegelin | 12 Oct |
| • Re: boolean search on phrase* | Visolve DB Team | 12 Oct |
| • RE: Boolean search on phrase* | Jerry Schwartz | 12 Oct |
| • Re: boolean search on phrase* | C.R.Vegelin | 12 Oct |
| • Re: boolean search on phrase* | Visolve DB Team | 12 Oct |
| • Re: boolean search on phrase* | C.R.Vegelin | 12 Oct |
| • Re: boolean search on phrase* | C.R.Vegelin | 14 Oct |
