root@localhost/test>desc t1;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| c1    | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0,00 sec)

root@localhost/test>select * from t1;
+------+
| c1   |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
|    5 |
+------+
5 rows in set (0,00 sec)

root@localhost/test>select * from t1 where c1 in (1,2,3) and c1 not in (select 3);
+------+
| c1   |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0,00 sec)