ALTER TABLE `sta_User` CHANGE `degrees` `credentials` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; UPDATE `sta_Settings` SET `description` = REPLACE(`description`, '{degrees}', '{credentials}'), `value` = REPLACE(`value`, '{degrees}', '{credentials}') WHERE `description` LIKE '%{degrees}%' OR `value` LIKE '%{degrees}%'; ALTER TABLE `sta_User` DROP `companyWebsite`;