Name

ISNULL( )

Synopsis

ISNULL(column)

Use this function to determine if the value of the argument given in parentheses is NULL. Returns 1 if it is NULL; 0 if it is not NULL.

SELECT ISNULL(col2)
FROM table1;

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.