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
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics