MySQL creates a high-performance index--spatial index (R-TREE)

Full-Text Indexing

A full-text index is a special class-type index that looks for keywords in text instead of directly comparing the values in the index.

A full-text index is more like what a search engine does, rather than a simple where condition match.

Full-text search and several other types of indexes match in a completely different way. It has many details that need attention, such as discontinued words, stems, complex numbers, Boolean searches, and so on.

The full-text index applies to the match against operation, not to the normal where condition operation.

MySQL creates a high-performance index--spatial index (R-TREE)