MySQL IS NULL Condition

Last Updated: 26 June, 2023

In MySQL, the keyword "NULL" represents the absence of a value or the unknown value for a particular data field. When we use the "IS NULL" condition in a query, it allows us to check if a column or expression has a NULL value.

Here's a syntax of how we can use "IS NULL" in a MySQL query:

 SELECT column_name FROM table_name WHERE column_name IS NULL;

In the above query, replace "column_name" with the name of the specific column we want to check for NULL values, and "table_name" with the name of the table where the column exists. This query will retrieve all rows where the specified column has a NULL value.

Here's an example of how we can use "IS NULL" in a MySQL query:

 SELECT emp_name, designation FROM employee WHERE address IS NULL;

Remember, when comparing NULL values, you need to use the "IS NULL" or "IS NOT NULL" conditions rather than the usual equality (=) or inequality (!=) operators, as those operators won't work correctly with NULL values.