mysql - WHERE id != 1 AND id != 2 AND id != 7 是否有更清晰的语法

Question

有没有更简洁的方法在 MySQL 中执行此查询？

SELECT * FROM table WHERE id != 1 AND id != 2 AND id != 7

喜欢:

SELECT * FROM table WHERE id != (1,2,7)

Answer 1

SELECT * FROM table WHERE id NOT IN (1,2,7)