需要这么写
UPDATE hrrecruit_position_ex_map e INNER JOIN (SELECT p.ID FROM `hrrecruit_position_ex_map` p WHERE p.POSITION_NAME_EX like '%好耶%') s SET e.POSITION_NAME_EX='工程师' WHERE e.ID = s.ID
需要这么写
UPDATE hrrecruit_position_ex_map e INNER JOIN (SELECT p.ID FROM `hrrecruit_position_ex_map` p WHERE p.POSITION_NAME_EX like '%好耶%') s SET e.POSITION_NAME_EX='工程师' WHERE e.ID = s.ID