Mysql full-text search index fields improve search efficiency

Although this method is feasible, the LIKE statement in a SELECT query is an extremely inefficient method for full-text search, especially when processing a large amount of data.

Developers only need to simply Mark Fields that require full-text search, and then use special MySQL methods to run search on those fields, this not only improves the performance and efficiency (because MySQL indexes these fields to optimize the search), but also achieves higher quality search, because MySQL uses natural language to intelligently rate the results to remove irrelevant items.

Table creation:

ALTERTABLE table name ADDFULLTEXTINDEX (Table field );

Run the SHOWINDEXES command to check whether the index has been added.

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

SELECT Table field FROM table name WHEREMATCH (full-text search table field) AGAINST ('search string ');

Last show result