Mysql 替换数据中的部分内容,比如迁移服务器,需要修改图片地址 UPDATE person SET urls = (REPLACE(urls,'xh',id)); UPDATE person SET urls = (REPLACE(urls,'xh','hx'));