摘要：SELECT WorkNo FROM SY_TrackNum WHERE WorkNo LIKE '%N+S' --UPDATE SY_TrackNum SET WorkNo = replace (WorkNo,'http://*.*.*.*','http://*.*.*.*') WHERE 1=1 阅读全文