update
表名
set
字段名=
replace
(
cast
(与前面一样的字段名
as
varchar
(8000)) ,
'原本内容'
,
'想要替换成什么'
)
update News set news_detail=replace(cast(news_detail as varchar(8000)) ,'http://tengxin.hotcenkj.com','http://m.gzfx88.com')
update
表名
set
字段名=
replace
(
cast
(与前面一样的字段名
as
varchar
(8000)) ,
'原本内容'
,
'想要替换成什么'
)
update News set news_detail=replace(cast(news_detail as varchar(8000)) ,'http://tengxin.hotcenkj.com','http://m.gzfx88.com')
转载于:https://www.cnblogs.com/ProDoctor/p/5999283.html