SQL 查找替换

应用场景：更改文章中文件路径

update SiteContents 
set Cont=REPLACE(Cont,'/UserFiles/Image/','/editor/userfiles/image/20130604/') 
where LogMsg like '批量导入%' and cont COLLATE Chinese_PRC_CS_AS like '%/UserFiles/Image/%'

备注说明：

REPLACE(Cont,'old value','new value')

不区分大小写 ：COLLATE Chinese_PRC_CI_AS

区分大小写 : COLLATE Chinese_PRC_CS_AS

转载于:https://www.cnblogs.com/linyongqin/articles/9366092.html