1、查找 then a.sh、then a.sbjj、then a.athg等等 then a.([\w]+[a-zA-Z]) 2、替换 then IFNULL(a.sh,0)等等 THEN IFNULL(a.\1,0)