mysql 替换字段中某几个字符并更新

UPDATE `database`.`table` 
SET `column` = REPLACE(column,'旧字符串','新字符串');