ALTER TABLE tbl MODIFY COLUMN type ENUM('fish','mammal','bird','insect');
NOT NULL, and any other qualifiers that originally existed, else they will be lost.
ALTERis done by merely changing the schema. That is there will not be a lengthy table copy. (Old versions of MySQL did not have this optimization.)