There are several possible reasons why the Mysql MATCH AGAINST function may fail to locate a string with a dot:
The dot may be considered as a word delimiter, therefore the search algorithm may ignore it. This is because Mysql considers certain characters, including the dot, as word delimiters or stop words.
The dot may be part of a larger word that has been excluded from the search index. By default, Mysql ignores words that are too common, too short, or too long, or those that appear in more than 50% of the rows.
The MATCH AGAINST function may not be suitable for searching for strings with dots, as it uses a full-text search algorithm that is optimized for natural language queries, rather than precise match queries.
To overcome these limitations, you can try using other search functions or methods, such as regular expressions, string comparison operators, or custom search algorithms. You can also modify the configuration of the Mysql full-text search index, to include or exclude specific words or characters.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2021-10-31 11:00:00 +0000
Seen: 17 times
Last updated: Apr 14 '21
How to deal with an operational error when connecting Django to MySQL?
In this scenario, what is the reason for the WHERE clause in MySQL to produce zero rows?
How can multiple queries be merged into a single stored procedure in MySQL?
What is the method for verifying the existence of a mysql database?
What does "waiting for handler commit" mean in relation to the slow writes experienced in MySQL 8?
What is the process for implementing a Many to Many relationship using NestJs Sequlize and Mysql2?
How can Spring Boot and Mysql be utilized for CRUD operations?
How can I refine the results for a specific column in MySQL?