Hi,

I often use something like 'SELECT * FROM table WHERE id IN (1,2,3)', but how do I do the opposite? Let's say I want to select everyone except those with id 1,2 or 3. I've tried with things like NOT IN or NOTIN, but didn't work, and searching the documentation on mysql.com gave nothing, so I hope someone can answer me.