更新时间:2022-12-10 21:20:25
UPDATE RIA.Contact
SET title = REPLACE(
REPLACE(
REPLACE(
REPLACE(title, 'Excutive', 'Executive'),
'Manging', 'Managing'),
'Manger', 'Manager'),
'Cheif', 'Chief')
WHERE title rlike 'Cheif'
OR title rlike 'Manger'
OR title rlike 'Manging'
OR title rlike 'Excutive';