update 表名 字段=REPLACE(字段,old,new);
update eemp_track set evi_pkg_url=REPLACE(evi_pkg_url,"https://eemp.filoink.cn","http://eemp. filolink.com");
根据条件批量替换:
update eemp_track t set
evi_pkg_url=REPLACE(evi_pkg_url,"https://eemp.filoink.cn","http://eemp. filolink.com") ,
evi_img_url=REPLACE(evi_img_url,"https://eemp.filoink.cn","http://eemp. filolink.com"),
cert_url=REPLACE(cert_url,"https://eemp.filoink.cn","http://eemp. filolink.com")
where t.create_time<20200301 and t.create_time>=20200220