MySQL IS NOT NULL operator
IS NOT NULL operator
MySQL IS NOT NULL operator will check whether a value is not NULL.
Syntax:
IS NOT NULL
MySQL Version: 8.0
Example: MySQL IS NOT NULL operator
The following MySQL statement it is checked whether 5, 0 and NULL is not NULL.
Code:
SELECT 5 IS NOT NULL,0 IS NOT NULL, NULL IS NOT NULL;
Output:
mysql> SELECT 5 IS NOT NULL,0 IS NOT NULL, NULL IS NOT NULL; +---------------+---------------+------------------+ | 5 IS NOT NULL | 0 IS NOT NULL | NULL IS NOT NULL | +---------------+---------------+------------------+ | 1 | 1 | 0 | +---------------+---------------+------------------+ 1 row in set (0.00 sec)
Slideshow of MySQL Comparison Function and Operators
Previous: INTERVAL()
Next: IS NOT
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics