MySQL IS NULL condition is used to check if there is a NULL value in the expression. It is used with SELECT, INSERT, UPDATE and DELETE statement.
- expression IS NULL
expression: It specifies a value to test if it is NULL value.
Consider a table “officers” having the following data.
Execute the following query:
- SELECT *
- FROM officers
- WHERE officer_name IS NULL;
Note: Here, you are getting the empty result because there is no NULL value in officer_name column.