• ⌂ Logical
• Functions
  • IF()
  • IFNULL()
  • ISNULL()
  • NULLIF()

ISNULL()

Return TRUE if expression evaluates to NULL, otherwise FALSE.

Prototype

boolean ISNULL(expression expression)

Parameters

• expression - Expression to evaluate.

Return

TRUE if expression evaluates to NULL, otherwise FALSE.

Example

SELECT OID, ISNULL(LastLogin.Timestamp) AS HasTime FROM User

Related

IF(), IFNULL()

• < IFNULL()
• NULLIF() >