IS NOT

Description

The IS NOT tests a value against a boolean value, where boolean_value can be TRUE, FALSE, or UNKNOWN.

Syntax

1. > IS NOT boolean_value

Examples

1. mysql> SELECT 1 IS NOT TRUE, 0 IS NOT FALSE, NULL IS NOT UNKNOWN;
2. +-----------+------------+----------+
3. | 1 != true | 0 != false | null !=  |
4. +-----------+------------+----------+
5. | false     | false      | NULL     |
6. +-----------+------------+----------+
7. 1 row in set (0.01 sec)