update `qs_UserAddress` set `type` = 'billing' where locate(',', `type`); ALTER TABLE `qs_UserAddress` CHANGE `type` `type` ENUM( 'home', 'billing', 'shipping' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;