Search word length
By default ke_search only finds words with a minimum length of four characters. This corresponds to the MySQL setting
ft_ which is set to 4 by default.
Hint
As standard ke_search uses MyISAM as storage engine for the index table.
The value can be adjusted by following these steps:
-
Change
ft_to the desired value in your MySQL configurationmin_ word_ len This can be done, e.g. in file
my.. In the example below it will set tocnf 3:[mysqld] ft_min_word_len = 3Copied!A better way would be on Debian-derived systems to use a file like
/etc/to separate the default values inmysql/ conf. d/ fulltext. cnf my.with your custom settings.cnf After the adjustment the MySQL server has to be restarted.
-
Set Basic > Change searchword length in the extension configuration to the same value
Change searchword length in the extension configuration
-
Re-index your content
Either by just running the indexer again (full indexing is necessary) or by executing the following SQL command:
REPAIR TABLE tx_kesearch_index QUICK;Copied!
Tip
Find more information about fine-tuning the full-text search in the MySQL documentation.