有个T_XZ_CASEINFO表的字段是caseid aaa10 aaa12 aaa13 要改成 kkk10kkk12kkk13 UPDATE T_XZ_CASEINFO SET caseid = REPLACE(caseid, 'aaa', 'kkk');