REPLACE 数据替换

select top 100 * from table_name order by inputdate desc

UPDATE bas_ImageList SET LinkUrl = REPLACE(LinkUrl,'http://test.oss-cn-hangzhou.aliyuncs.com','http://test-upload.oss-cn-hangzhou.aliyuncs.com')
WHERE linkurl like 'http://test.oss-cn-hangzhou.aliyuncs.com%'

UPDATE bas_ImageList SET PicWebUrl = REPLACE(PicWebUrl,'http://test.oss-cn-hangzhou.aliyuncs.com','http://test-upload.oss-cn-hangzhou.aliyuncs.com')
WHERE PicWebUrl like 'http://test.oss-cn-hangzhou.aliyuncs.com%'

 

select * from table_name 

UPDATE bas_ProductInfoDrawingDetail SET Url = REPLACE(Url,'http://test.oss-cn-hangzhou.aliyuncs.com','http://test-upload.oss-cn-hangzhou.aliyuncs.com')
WHERE Url like 'http://test.oss-cn-hangzhou.aliyuncs.com%'

UPDATE bas_ProductInfoDrawingDetail SET PicUrl = REPLACE(PicUrl,'http://test.oss-cn-hangzhou.aliyuncs.com','http://test-upload.oss-cn-hangzhou.aliyuncs.com')
WHERE PicUrl like 'http://test.oss-cn-hangzhou.aliyuncs.com%'