mysql 批量替换字符串

UPDATE tb_content

SET scontent = REPLACE(scontent, ‘/upload/’, ‘http://xxx.com/website/upload/’)

syntax

update table set column = replace(column,originstring,replacestring)