I’m running this query
SELECT * FROM stockcategories_fr WHERE MATCH('@mycolumn ^t-shirt|^tee-shirt|^ tee-shirt|^ t-shirt');
It returns results :
T-shirts
T-shirts enfant
…
But if I run this query
SELECT * FROM stockcategories_fr WHERE MATCH('@mycolumn ^tee-shirt|^ tee-shirt|^t-shirt|^ t-shirt');
It returns no result.
I just changed the order of OR conditions in the MATCH clause.
For further information, mycolumn does not contain “tee-shirt” words.
Am i doing something wrong ?