Compares an expression or value and determines whether it is NULL.

Syntax


expression IS [ NOT ] NULL

Arguments

  • expression: an expression.

Returns

  • True or false.

Examples


SELECT * FROM MYSQL.inventory.cust WHERE grossPay IS NOT NULL;