m meShell 全干工程师 2017/12/13 14:53 在SQL中更新替换字符串 T-SQL: update TBL set picture = Replace(picture, 'servera', 'serverb') where picture like '%servera%'SQLCopy Oracle: update TBL set picture = replace(picture, 'servera', 'serverb') where picture like '%servera%'SQLCopy MySQL: update TBL set picture = REPLACE(picture, 'servera', 'serverb') where picture like '%servera%'SQLCopy