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