Hi Aaron, that would need to be accomplished in 3 several steps I believe.
1) Add the prurple option with an ALTER command 2) REPLACE Blue with purple 3) ALTER the enum type again (remove blue option) While I dont understand the meaning/background on this it might be a good idea to keep the value blue as it contains information such as that you know which data record was orginally meant to conatin the value "blue". Onceyou converted all to purple you will not be able to retrieve this information anymore. Best regards Nils Valentin Tokyo/Japan 2003年 7月 18日 金曜日 06:49、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 > [EMAIL PROTECTED] > (541)494-6900 > > You can destroy your now by worrying about tomorrow. > -- Janis Joplin -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]