Administrators/Change fulltext minimum length

By default, the MySQL server stores only words with at least four characters into the fulltext index (and if it's not a stop word). To add shorter words (e.g. with three characters) to the index, you have to adapt the MySQL ft_min_word_len setting in the my.cnf configuration file:

ft_min_word_len = 3

Afterwards, you have to rebuild the fulltext index with

REPAIR TABLE mshop_catalog_index_text QUICK