IS NOT NULL in MySQL

by

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

Syntax:

WHERE expression IS NOT 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	
7	David

Query:

SELECT name
FROM students
WHERE age IS NOT NULL;

Output:

NAME
Joy
Smiley
Happy
Tom
Jerry
5 rows  in set <0.12 sec>