用 not in,如:
delete from users where id not in (1,2,3,4)
或者 id 通过查询获得,如:
delete from users where id not in (select id from users where id>100 and id<200)