Known problems
Searching for hy-phen-at-ed words
When using the fulltext index feature, searching for words with hyphens in them ("Berners-Lee") will yield no results when MySQL is used as database server. MariaDB does not have this problem.
The reason for this behavior is that the MySQL fulltext parser indexes words with hyphens as two words: "Berners Lee".
Another problem is that the "fulltext search minimum word length" setting
ft_
default value is 4
, which means that three-letter
words are not indexed at all.
Of "Berners-Lee", only "Berners" will be in the index.