mysql search 索引_mysql全文搜索索引的字段提高搜索效率（MySQL full-text search index field to improve search efficiency...

mysql全文搜索索引的字段提高搜索效率(MySQL full-text search index field to improve search efficiency)

mysql全文搜索索引的字段提高搜索效率(MySQL full-text search index field to improve search efficiency)

The LIKE statement in a SELECT query performs this query, although this approach is feasible, but it is a very inefficient method for full text lookups, especially when dealing with large amounts of data.

Developers only need to simply mark fields to find, and then use the MySQL method in the field of special search operation, which not only improves the performance and efficiency (because of MySQL, these fields do to optimize the search index), and achieve a higher quality of the search for MySQL using the natural language of intelligence the results of rating, to remove irrelevant items.

Build table:

ALTER TABLE table name ADD, FULLTEXT, INDEX (table field);

Use the SHOW INDEXES command to check that the index has been added

With data and indexes, you can use the full text search of MySQL, and the simplest full-text search method is the SELECT query with the MATCH / AGAINST statement:

SELECT table field, FROM table name, WHERE MATCH (full text search table field), AGAINST (search string ');

Today announced a I write a IE monitoring program, write up really tired, intended to make a query site, because of the time did not do, only to write a query program, are free to write a website, it is also convenient, IE OK) below: that is that.

Program composition: a total of four files, and two batches, plus an MYSQL database.

LibmySQL.dll and MYIE.dll send the data from the client to the server. Libmysql.dll maybe everyone is not strange, yeah, he's MySQL's API, and MYIE.dll is my plug-in for IE. MYIECONFIG.exe is the tool to configure the parameters required for MYIE.dll.

MYIESEE.exe is a tool for checking other people's online records, that is, what is said to be a substitute for a website

The two batch is install.bat, which is used to register MYIE.dll, and uninstall.bat is to cancel the registration.

Installation method:

1. server installation: download the MYIESERVER.rar, put it in a