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.
In today's fast-paced digital world, the logistics and supply chain sector is encountering unprecedented challenges…
Website navigation and speed play a significant role in the success of online business. Attractive…
Welcome to your ultimate guide to Jackpot joy, the crown jewel of UK online casinos!…
The demand for mobile apps has risen rapidly. The reason? The modern customers proactively rely…
In recent years, a significant shift has occurred in the automotive industry as electric vehicles…
Goa is a tiny emerald state of India which is quite famous for attracting tourists…