试试这个UPDATE post SET active = '1' WHERE `user` = '".$my['id']."' and id not IN ( SELECT id FROM ( SELECT id FROM post WHERE `user` = '".$my['id']."' ORDER BY id ASC LIMIT 0, 5 ) tmp)