Negation Conditions
The NOT
operator reverses the meaning of a condition. It returns true if the condition is false. It returns false if the condition is true.
Syntax
NOT {BETWEEN | IN | LIKE | NULL }
Example
5 IS NOT NULL
is true; 5 NOT IN (5, 10, 15)
is false.