Enabling the knowledge base search to look for the short words

A Knowledge Base comprises of a number of articles. So it is essential for a user to be able to search for the relevant articles by specifying the keywords in the search query string. Knowledge Base search is performed at the Client Support Center by using the Search bar or while submitting new tickets.

The Knowledge Base search uses Full-Text search and the words should not be less than 4 characters in length.

To overcome this limitation so that clients can search the Knowledge Base articles by specifying 3 character words, the following change needs to be done:

  1. Specify the value 3 for the variable ft_min_word_len in the my.ini file (Windows server) or in the my.cnf file (Linux server).
  2. Once done, restart your MySQL service.