Changing the minimum word length allowed for searching
Published byGeorge Papadakis
Last modified28 October 2013
Up to dateYes
Profile concernedEnd user, Webdesigner, Developer
VotingAverage rating3 votes
FavouritesClick to subscribeTotal: 1 users
When using the flexicontent search view, you may want to change the minimum search word length allowed.
Note that both FLEXIcontent and MySql pose a limit to this
- Set a minimum characters in the menu item pointing to search view
- Edit mysql.ini (or mysql.cnf, or my.ini) file and change variable "ft_min_word_len" to put a lower limit, e.g.:
# The MySQL serveryou may want to ask your webhost support to do this for you,
there is little overhead in reducing this to a value of 3 or 2,
since the MySQL index will ignore the very common short words e.g. 'to'
- run in phpmyadmin
REPAIR TABLE ppp_flexicontent_items_ext REPAIR TABLE ppp_flexicontent_advsearch_indexthis will make the search indexes to recreated/updated