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;
WHERE expression IS NOT NULL;
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
ID NAME AGE
1 Joy 5
2 Smiley 13
3 Happy 11
4 Tom 15
5 Jerry 10
6 Bruno
7 David
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;
SELECT name
FROM students
WHERE age IS NOT NULL;
SELECT name FROM students WHERE age IS NOT NULL;
Output:
NAME
Joy
Smiley
Happy
Tom
Jerry
5 rows in set <0.12 sec>
NAME
Joy
Smiley
Happy
Tom
Jerry
5 rows in set <0.12 sec>
NAME Joy Smiley Happy Tom Jerry 5 rows in set <0.12 sec>