sql语句把字段中的某个字符去掉

时间：2016-11-14 14:59:48 收藏：0 阅读：763

sql语句把字段中的某个字符去掉

update Notifications set Accessory=replace(Cast(Accessory as varchar(8000)),‘http://demo.m-school.net‘,‘‘)

例如：

update Notifications set Accessory=replace(Cast(Accessory as varchar(8000)),‘http://192.168.2.180‘,‘‘)
update Notifications set Accessory=replace(Cast(Accessory as varchar(8000)),‘http://zpzx.m-school.net‘,‘‘)
update Homeworks set Accessory=replace(Cast(Accessory as varchar(8000)),‘http://192.168.2.180‘,‘‘)
update Homeworks set Accessory=replace(Cast(Accessory as varchar(8000)),‘http://zpzx.m-school.net‘,‘‘)
update OpenCourses set Attachment=replace(Cast(Attachment as varchar(8000)),‘http://192.168.2.180‘,‘‘)
update OpenCourses set Attachment=replace(Cast(Attachment as varchar(8000)),‘http://zpzx.m-school.net‘,‘‘)
update OpenCourses set Audio=replace(Cast(Audio as varchar(8000)),‘http://192.168.2.180‘,‘‘)
update OpenCourses set Audio=replace(Cast(Audio as varchar(8000)),‘http://zpzx.m-school.net‘,‘‘)
update ListenCourses set Attachment=replace(Cast(Attachment as varchar(8000)),‘http://192.168.2.180‘,‘‘)
update ListenCourses set Attachment=replace(Cast(Attachment as varchar(8000)),‘http://zpzx.m-school.net‘,‘‘)
update ListenCourses set Audio=replace(Cast(Audio as varchar(8000)),‘http://192.168.2.180‘,‘‘)
update ListenCourses set Audio=replace(Cast(Audio as varchar(8000)),‘http://zpzx.m-school.net‘,‘‘)

老师，学生，家长头像：

update Sys_User set Portrait=replace(Portrait,‘http://zpzx.m-school.net‘,‘‘)
update Students set Portrait=replace(Portrait,‘http://zpzx.m-school.net‘,‘‘)
update Parents set Portrait=replace(Portrait,‘http://zpzx.m-school.net‘,‘‘)

原文：http://www.cnblogs.com/yechangzhong-826217795/p/6061525.html