Issue Bug Closed

#77644MySQL driver extension breaks searches with hyphens

Christian Rieke 08/25/16, 22:48 updated 10/04/22, 13:58

Description

If the MySQL driver extension is used, search phrases with a hyphen such as “eq-5d” will return “no results”. This occurs quite often in German language sites, but also when searching for dates (“2016-25-08”) or medical abbreviations (above).

The problem is probably due to the fact that MySQL itself does not handle full text searches with hyphens very well. One solution seems to be to use full text search IN BOOLEAN MODE. But that, in turn, would break relevance sorting.
My current workaround is to not use the MySQL driver at all.

Reviews 3