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
