Jump to content

Knowledge base: search for three-character words

stormy

By stormy
in Using WHMCS

 Share

Recommended Posts

stormy Senior Member

stormy

Posted
Posted

I've just realised that by default, MySQL doesn't return any search results for 3-letter words, such as DNS, FTP, etc. Obviously, this could be improved.

 

There's some official documentation here:

http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html

 

The parameter "ft_min_word_len=3" is the one controlling this.

 

Has any of you tried fine tuning MySQL so it will return these searches? Have you found any adverse effects?

0
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated

  I accept