ALTER TABLE `sta_User` CHANGE `directPhone` `workPhone` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; UPDATE `sta_Settings` SET `value` = REPLACE(`value`, 'Phone Number: {directPhone}', 'Work Phone Number: {workPhone}') WHERE `value` LIKE '%Phone Number: {directPhone}%' LIMIT 1; UPDATE `sta_Settings` SET `description` = REPLACE(`description`, '{directPhone}', '{workPhone}') WHERE `description` LIKE '%{directPhone}%';