Twitter 
Facebook
chevron_left
Operators
0
0
0
new
MySQL | IS NULL
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightOperators
schedule Jul 1, 2022
Last updated MySQL
Tags tocTable of Contents
expand_more MySQL's IS NULL operator tests whether a value is NULL. It returns 0 if the value is not NULL and 1 if the value is NULL.
Syntax
SELECT value IS NULL;SELECT column IS NULLFROM table_name;
Examples
Consider the following table about students' extracurricular activities:
student_id | club | date_entered |
|---|---|---|
1 | Football | 2016-02-13 |
2 | Boxing | 2016-05-25 |
3 | Apple | 2018-08-17 |
4 | Fishing | 2017-01-01 |
5 | NULL | NULL |
The above sample table can be created using the code here.
Basic usage
To check whether club is NULL for each student:
SELECT student_id, club IS NULL FROM extracurricular;
+------------+--------------+| student_id | club IS NULL |+------------+--------------+| 1 | 0 || 2 | 0 || 3 | 0 || 4 | 0 || 5 | 1 |+------------+--------------+
Note that club IS NULL returns 1 for student_id=5 as the student is not part of any club.
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_is-null
0
0
0
Enjoy our search
