UPDATE dbo.authors SET city = replace(city, 'Salt', 'Olympic') WHERE city LIKE 'Salt%'; 转载于:https://www.cnblogs.com/youhaoxinqin/p/3495281.html