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