mysql 表这段内容替换

update `cr_article` set `img`=replace(`img`,'http://192.168.2.10/upload','http://zouke1220.oss-cn-beijing.aliyuncs.com');
update `cr_article` set `content`=replace(`content`,'http://192.168.2.10/upload','http://zouke1220.oss-cn-beijing.aliyuncs.com');

 

posted @ 2018-11-08 14:18  邹柯  阅读(303)  评论(0编辑  收藏  举报