有个字段是id aaa10 aaa12 aaa13 。。。 要改成 kkk10 kkk12 kkk13 UPDATE tablename SET id = REPLACE(id, 'aaa', 'kkk');