Dropping and Rebuilding Full-Text Indexes

Rebuilding Full-Text Indexes

After changing stopwords or token size configuration, drop and recreate all full-text indexes to apply the new settings.

Example

-- Drop full-text index
ALTER TABLE articles DROP INDEX idx_search;

-- Recreate with new settings
ALTER TABLE articles ADD FULLTEXT idx_search (title, body);

-- Alternatively
DROP INDEX idx_search ON articles;
CREATE FULLTEXT INDEX idx_search ON articles (title, body);

SQL

Full Editor

Pro Tip

Dropping and recreating a full-text index can take time on large tables — plan for downtime.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned