NOT and IN Operator in mysql

• NOT is to negate a condition. When, NOT operator is placed in front of the IN Operator, it negate the condition
• IN Operator defines a list of condition that can be matched. IN operator takes a comma-delimited list of valid values, and enclosed within a parentheses

>>SELECT * FROM user;
>>SELECT * FROM user WHERE age IN(21,13,23);
>>SELECT * FROM user WHERE age NOT IN(21,13,23);