I am following an example in my book dealing with an ENUM data-type.

My table already has values in it, and I would like to change one ENUM value from "Admin" to "Administrator" and also change the corresponding field values.

How would I do this?


Debbie