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.
Run show variables like ‘ft_%’; to confirm that the word length matches what you set it to.
ft_min_word_len = 4
You can change the effect by updating the ft_min_word_len variable in the my.cnf MySQL configuration file:
[mysqld]
ft_min_word_len = 3
Then you must restart the server and rebuild your FULLTEXT indexes.
For avoiding this issue, in this case, you can still use LIKE:
‘%$keyword%’ LIKE CONCAT(‘%’, Column, ‘%’)
Or regular expression:
‘%$keyword%’ REGEXP Column
For any types of queries, you can contact us on info[at]namasteui.com.
Sinus infections, impacting approximately 31 million Americans each year, represent a significant health concern stemming…
Pros And Cons Of AI: Artificial Intelligence directly translates to conceptualizing and building machines that…
We all live on the internet; we use it for everything. Thus, when it comes…
Introduction: Pink eye, or conjunctivitis, is a common eye condition characterized by redness and inflammation…
Small businesses are the backbone of the economy. Still, they often face daunting hurdles when…
Introduction: As the chill of winter settles in or a bout of cold weather strikes,…