sql 替换指定字段中的制定内容

update YJ_WebImg set ImgSrc = replace(cast(ImgSrc as varchar(8000)),'upload','uploadImg')
 
 
//当字段是text 类型   需要先转化

update YJ_WebImg set Smallimg = replace(Smallimg,'upload','uploadImg')