update 表名 set 字段= replace(字段,'原字符','新字符');
示例:
tb_item表中image字段中一数据为:jd/4ef8861cf6854de9889f3db9b24dc371.jpg
update tb_item set image = replace(image,'jd','taobao');
替换后:
taobao/4ef8861cf6854de9889f3db9b24dc371.jpg
update 表名 set 字段= replace(字段,'原字符','新字符');
示例:
tb_item表中image字段中一数据为:jd/4ef8861cf6854de9889f3db9b24dc371.jpg
update tb_item set image = replace(image,'jd','taobao');
替换后:
taobao/4ef8861cf6854de9889f3db9b24dc371.jpg