What Is a Fulltext Index

First, specify the name of the table that you want to create the index after the ALTER TABLE keywords.Second, use the ADD FULLTEXT clause to define the FULLTEXT index for one or more columns of the table.

How do you use fulltext index?

1. First, specify the name of the table that you want to create the index after the ALTER TABLE keywords.
2. Second, use the ADD FULLTEXT clause to define the FULLTEXT index for one or more columns of the table.

What is a fulltext index in MySQL?

Full-text indexes are created on text-based columns ( CHAR , VARCHAR , or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX .