w3resource

MySQL IS NOT operator

IS NOT operator

MySQL IS NOT operator will test a value against a boolean value. A boolean value can be TRUE, FALSE, or UNKNOWN.

Syntax:

IS NOT boolean_value

MySQL Version: 8.0

Example: MySQL IS NOT operator

The following MySQL statement it is checked whether 2, 0 and NULL is not unknown.

Code:

SELECT 2 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;

Output:

mysql> SELECT 2 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;
+------------------+------------------+---------------------+
| 2 IS NOT UNKNOWN | 0 IS NOT UNKNOWN | NULL IS NOT UNKNOWN |
+------------------+------------------+---------------------+
|                1 |                1 |                   0 | 
+------------------+------------------+---------------------+
1 row in set (0.00 sec)

Slideshow of MySQL Comparison Function and Operators

Previous: IS NOT NULL
Next: IS NULL



Follow us on Facebook and Twitter for latest update.