How to deal with the minimum value of mysql full-text index

Mysql full-text index can solve the problem of fuzzy query. The following describes how to solve the problem of the minimum value of mysql full-text index. This method is for your reference and may be helpful to you.

In general, the like Statement of SQL is used for database search, and the like statement cannot use indexes. Each query goes from the first to the last one, and the query efficiency is extremely low. Generally, if the data exceeds 0.1 million or the number of online users is too large, like queries may cause database crashes. This is why many programs only provide title search, because if the content is searched, it will be slower and tens of thousands of data will not run.

Mysql full-text index is designed to solve fuzzy queries. You can index the entire article by words in advance, which is highly efficient in search and supports retrieval of millions of data records.

If you are using your own server, set it immediately. Do not waste this function.

If you are using a virtual host, please immediately contact the Space Provider to modify the configuration. First, this default value of Mysql is an incorrect setting for Chinese characters. The modification is equal to correct the error. Second, the configuration modification is very simple, that is, a few minutes, and the improved search efficiency also reduces the chance of the Space Provider database downtime. If you send this article to a space provider, I believe most of them will be willing to change.

Mysql full-text index setting method:

Modify my. ini Linux to my. cnf), add "ft_min_word_len = 1" to the end of [mysqld], restart Mysql, and run repair table table_name quick to recreate the index.

How to view MySQL Indexes

MySQL database connection command

Three statuses of mysql triggers

Create MySQL trigger syntax

Three examples of mysql triggers