Search word length¶
By default ke_search only finds words with a minimum length of four characters. This corresponds to the MySQL setting
ft_min_word_len
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_min_word_len
to the desired value in your MySQL configurationThis can be done, e.g. in file
my.cnf
. In the example below it will set to3
:[mysqld] ft_min_word_len = 3
A better way would be on Debian-derived systems to use a file like
/etc/mysql/conf.d/fulltext.cnf
to separate the default values inmy.cnf
with your custom settings.After the adjustment the MySQL server has to be restarted.
Set Basic > Change searchword length in the extension configuration to the same value
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;
Tip
Find more information about fine-tuning the full-text search in the MySQL documentation.