且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

请帮助将 4 个 MySQL 查询合并为一个

更新时间: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';