目标：

把主键为*abc???.aaa.com的去除，把*abc???-1.aaa.com的记录行主键字段改为*abc???.aaa.com。

把主键为*abc???.bbb1.com的去除，把*abc???-1.bbb1.com的记录行主键字段改为*abc???.bbb1.com。

语句：

delete from TBLAAA WHERE NAME LIKE '%abc___.aaa.com';
update WBXSMTTBLAAA set NAME =concat(left(NAME ,length(NAME )-9),'.aaa.com') where NAME LIKE '%abc___-1.aaa.com';
delete from TBLAAA WHERE NAME LIKE 'e%abc___.bbb1.com';
update TBLAAA set NAME =concat(left(NAME ,length(NAME )-10),'.bbb1.com') where NAME LIKE '%abc___-1.bbb1.com';

本文转自 dannyy1026 51CTO博客，原文链接:http://blog.51cto.com/dannyyuan/44222