MySQL IS NOT NULL Condition

MySQL IS NOT NULL condition is used to check the NOT NULL value in the expression. It is used with SELECT, INSERT, UPDATE and DELETE statements.

Syntax:

snippet
expression IS NOT NULL

Parameter

expression: It specifies a value to test if it is not NULL value.

MySQL IS NOT NULL Example

Consider a table "officers" having the following data.

MySQL IS NOT NULL Condition 1

Execute the following query:

snippet
SELECT *
FROM officers
WHERE officer_name IS NOT NULL;

Output:

MySQL IS NOT NULL Condition 2

Note: Here, you are getting the complete "officers" table as result because every value is NOT NULL in the table.

Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +