What does mysql full text index refer to?

Description

1. The MyISAM storage engine supports full-text indexing, which is used to find keywords in the text instead of directly comparing whether they are equal.

The search condition uses MATCH AGAINST instead of ordinary WHERE.

2. Full-text index is implemented using inverted index, which records the mapping of keywords to the document where they are located.

The InnoDB storage engine also begins to support full-text indexing in MySQL 5.6.4.

Example

Create a full-text index when creating a table.

    CREATE TABLE article (
                  id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
                  title VARCHAR(200),
                  content TEXT,
                  FULLTEXT(title, content)
              ) TYPE=MYISAM;

The above is the detailed content of What does mysql full text index refer to?. For more information, please follow other related articles on the PHP Chinese website!