In MySQL, while searching column using MATCH AGAINST keywords then the result matches all the row with search character more than 3. If you see the system variable ft_min_word_len, which specifies the minimum length of words to be indexed by full-text searching, it defaults to 4, so 3-letter words won’t be found by full-text searching. […]
