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 = 3
Copied!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
-
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.