Todays lesson we learn how to find, drop and replace a fulltext index against a table in mysql4.
- The first thing to do is to read the fulltext and table chapters of the mysql manual
-
Next we find the table and choose our database
-
Next we find the indexes for the table using 'show index from tablename' where tablename is your table name.
-
Next we remove the fulltext index using the name of its key as found in the results of the show index query i.e. 'alter table tablename drop index fulltextindexkeyname'
easy
