Hi!

I am wondering if MySQL treats the dash in "add-ons" for example as a "not" operator since the query doesn't return any results although the field contains the word "add-on".
If yes, is it possible to tell MySQL to treat the dash as string?

Regards,
Sebastian

Edit: The table is indexed since the same query for "addon" works when the table contains "addon".

Just had a look at MySQL bug #3150 and found out that it is related to the word-length. Since the dash is not a legal word character and "add" has only three characters nothing is returned.