MySQL NOT Condition

The MySQL NOT condition is opposite of MySQL IN condition. It is used to negate a condition in a SELECT, INSERT, UPDATE or DELETE statement.

MySQL NOT Syntax


NOT condition

MySQL NOT Example


SELECT *  
FROM army  
WHERE rank IS NOT NULL;