MySQL Full-text search index fields to improve search efficiency

A like statement in a SELECT query executes this query, although it works, but for full-text lookups this is an extremely inefficient approach, especially when dealing with large amounts of data.

Developers simply mark out fields that require Full-text lookup, and then run the search in those fields using a special MySQL method, which not only improves performance and efficiency (because MySQL indexes these fields to optimize the search), but also enables higher quality searches, Because MySQL uses natural language to intelligently rank results to get rid of irrelevant items.

Build table:

ALTER table name ADD fulltext INDEX (table field);

Use the show indexes command to check that the index has been added

With the data and index, you can use the full text of MySQL search, the simplest Full-text search method is with match ... Select query for against statement:

The SELECT table field from tables name WHERE MATCH (full-Text search table field) against (' search string ');

Final display Result