MYSQL Not equal to "IN" query

Question

I have a table with loads of id's but I don't want to select around 10 id's

First I tried multiple OR but that didn't work then found the IN

SELECT * FROM table WHERE id IN (10, 88, 99)

But this selects those numbers I want all the other numbers so a not equal to needs to go in somewhere

Answer 1

Try this:

 SELECT * FROM table WHERE id NOT IN (10, 88, 99)

Hope this helps