By default, searching the content of documents does not return words that are less than 4 characters long.
This number of characters, set by MySQL, can be changed in the MySQL configuration file by specifying the value ft_min_word_len. The default value is 4. Changing it to 3 will return 3-letter words. my.cnf
[mysqld] ft_min_word_len=3
Configuration File Path:
- Debian: /etc/mysql/my.cnf
- Windows: C:Program Files (x86)OpenBeeOpenBeePortal5mysqlmy.ini
Restart MySQL after the configuration has been changed.
More info: http://dev.mysql.com/doc/refman/5.5/en/fulltext-fine-tuning.html