IS NULL in MySQL

MySQL IS NULL
To filter the results, the MySQL IS NULL condition is used with SELECT, INSERT, UPDATE and DELETE statements to check for a NULL value.

Syntax:

WHERE expression IS NULL;


Parameters:
expression: It is used to specify a column or a field to be tested.

Example:
Students table:

 ID NAME AGE 1 Joy 5 2 Smiley 13 3 Happy 11 4 Tom 15 5 Jerry 10 6 Bruno NULL 7 David NULL

Query:

SELECT name FROM students WHERE age IS NULL;

Output:

NAME
Bruno
David
2 rows  in set <0.00 sec>