How to alter enum type value in table?

[Anon]

I am using MySQL.

I have in some tables enum columns but now and then I need to change one of the values of enum type.

How do I do this without loosing any data in my tablerows?

[Anon]

I don't know if that can help you...

When I have to update a table that contain enum type, I do this:

TABLE Car
Color enum('Blue', 'Red')

update Car set Color='Red' where ...

Bbp

[Anon]

Sorry, no. That is not the problem. I need to change the enum type itself with something like:

alter table myTable change myColumn enum('Blue','Red') newColumn enum('cold','varm');

Where Blue changes to cold and red to varm. both in the table definition and in the table rows.