Changing ENUM Values

[Aaron Blew]

So I've got fairly big sized table (20,000 records) which has an ENUM
row. I need to change the name of one of the ENUM options. For
example, if the ENUM value was 'blue' before, it needs to be 'purple'
now. What's the best way to do this?

Thanks,
-Aaron
---------------
Aaron Blew
Jackson County School District #6 Network/Systems Analyst
aa********@district6.org
[phone]

You can destroy your now by worrying about tomorrow.
-- Janis Joplin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw