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 subscribe
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