ActiveSPLIT.com

To disable MySQL FULLTEXT Search stopwords open the mysql config file and below [mysqld] add the following line:
ft_stopword_file = “”
By setting the ft_stopword_file value to an empty string the usual stopwords won’t be ignored any more.
Here is what the manual says about setting a new stopwords file:
To override the default stopword list, set the ft_stopword_file [...]

By default the FULLTEXT minimum characters behaviour is set to 4 characters. To check what value is preset on your server type the following query:
SHOW VARIABLES LIKE ‘ft%’;
That shoud bring up a result similar to this:

Variable_name
Value

ft_boolean_syntax
+ -><()~*:””&|

ft_max_word_len
84

ft_min_word_len
4

ft_query_expansion_limit
20

ft_stopword_file
(built-in)

To change the ftp_min_word_len you have to edit the my.ini configuration file.
Below [mysqld] add this line to decrease the [...]