sql 替换指定字段中的制定内容
update YJ_WebImg set ImgSrc = replace(cast(ImgSrc as varchar(8000)),'upload','uploadImg') //当字段是text 类型 需要先转化 update YJ_WebImg set Smallimg = replace(Smallimg,'upload','uploadImg')
update YJ_WebImg set ImgSrc = replace(cast(ImgSrc as varchar(8000)),'upload','uploadImg') //当字段是text 类型 需要先转化 update YJ_WebImg set Smallimg = replace(Smallimg,'upload','uploadImg')