Changing the sort ordering of an existing ENUM field

[Avram Aelony]

hi,

I have a table with a 'priority' field defined as an ENUM:
priority enum('SOMEDAY','NOW','SOON') NOT NULL
I would like to change it to the following so the sort order is more 
intuitive/desirable.
priority enum('NOW','SOON', 'SOMEDAY') NOT NULL

I am guessing that some form of  ALTER TABLE  t MODIFY command is 
required, but I am hesitant as the database is populated and I do not 
wish to lose data if I can help it.  :)

Any help would be appreciated.

thanks,

Avram

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]