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
The management of a property isn't solely the process of collecting rental. It also involves…
Development and progression are not only essential but often one of the main goals of…
People usually stumble onto the 461 visa when they realise there’s no simple way to…
When you run a brick-and-mortar retail store, you encounter an array of customer personalities. From…
In today’s digital era, people look for convenience, transparency, and genuine rewards from their financial…
If you are planning to start a lighting business and looking for a supplier of…