Checking if a mysql row is NOT in an array

Question

I know that you can use

WHERE `age` IN ($ages)

to find rows where the column age equals a part of an array.

But what i need to find out is - What if you want to find rows where age is NOT in the array??

thanks

Michael Berkowski · Accepted Answer · 2011-07-29 13:19:26Z

10

You need NOT IN. Yep, it really is that simple.

$ages = "1,3,4,7,9";

// Your SQL WHERE clause...
WHERE `age` NOT IN ($ages)

answered Jul 29, 2011 at 13:19

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1