In MySQL IS NULL operator is used to check for NULL value in the SELECT, INSERT, UPDATE, or DELETE statement. If expression is a NULL value, the condition evaluates to TRUE otherwise FALSE.
To check for the NULL value in the field, use the following syntax:
tablename: The table name from which you want to perform
IS NULL operator.
expression: To test specifies value if it is NULL value.
IS NULLoperator is used to check for the NULL value in the "address" field:
In the above example, we are performing
IS NULL operator to check for the NULL value in the "address" field.
You can use MySQL Command Line Client to perform
IS NULL operator to check for NULL value in the field. It will look like this: