3,491
社区成员
发帖
与我相关
我的任务
分享
update tablename
set colnumname=replace(colnum,'http://10.81.168.168:7002','http://127.0.0.1:9080')
--比如:
SELECT REPLACE('http://10.81.168.168:7002/crx?ajax....','10.81.168.168:7002','127.0.0.1:9080') FROM dual;
结果:
http://127.0.0.1:9080/crx?ajax....