Mysql Full Text Handling of Hyphens

[andrewm]

Hyphen '-' characters break literals at the moment. A search for something like "GATA-D22S690" finds all entries containing GATA and not the full
hyphenated text. The '-' character is treated as a word stop even within literals. The same is true if any of the special text search modifiers are used (eg
+, -, ~) so that hyphenated literals are not correctly found with full text searches.

Anyway to get around it?

[superwormy]

try escaping it

[andrewm]

Doesn't work.

Looks like there isn't a fix, except for doing each word individually, until the mysql team fixes it.

[superwormy]

Why don't you post some code / SQL? And what version of MySQL are you using?

I've just tested on both MySQL 3.23 and 4.01 and it works just fine...

[andrewm]

Edit:

I stand corrected.

We had mySQL updated over the weekend and the problem has been fixed.