Mysql 替换数据中的部分内容,比如迁移服务器,需要修改图片地址

UPDATE person SET urls = (REPLACE(urls,'xh',id));

UPDATE person SET urls = (REPLACE(urls,'xh','hx'));
原文地址:https://www.cnblogs.com/jiqing9006/p/15273004.html