In MySQL 4.1.21-standard - suppose you had an enum column like this:

CREATE TABLE sizes (name ENUM('1', '2', '3'));

Next suppose you have that table populated with a hundred names when suddenly you want to add the value '4' to the list of options.

Is there a way to modify the enum (add or delete) options without losing data?

Thanks,

~q