UPDATE `TABLE名` SET `欄位名` = REPLACE(`欄位名`, '要被取代的欄位值', '取代後的欄位值') WHERE `欄位名` LIKE '%欄位值%';
UPDATE `options` SET `title` = REPLACE(`title`, 'ssorc.tw', 'SSORC.TW') WHERE `title` LIKE '%ssorc.tw%';
UPDATE `TABLE名` SET `欄位名` = REPLACE(`欄位名`, '要被取代的欄位值', '取代後的欄位值') WHERE `欄位名` LIKE '%欄位值%';
UPDATE `options` SET `title` = REPLACE(`title`, 'ssorc.tw', 'SSORC.TW') WHERE `title` LIKE '%ssorc.tw%';
留言