把数据库中某个字段中的一个字符串,替换成另一个字符串
update TB_Student
set pic=replace(pic,'UploadImage/img0','www.xxx.com//UploadImage/img0')
where charindex('UploadImage/img0',pic)>0;
转载于:https://blog.51cto.com/zhaoguang/1584483
把数据库中某个字段中的一个字符串,替换成另一个字符串
update TB_Student
set pic=replace(pic,'UploadImage/img0','www.xxx.com//UploadImage/img0')
where charindex('UploadImage/img0',pic)>0;
转载于:https://blog.51cto.com/zhaoguang/1584483