THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL ISNULL() Function

❮ MySQL Functions

Example

Test whether an expression is NULL:

SELECT ISNULL(NULL);
Try it Yourself »

Definition and Usage

The ISNULL() function returns 1 or 0 depending on whether an expression is NULL.

If expression is NULL, this function returns 1. Otherwise, it returns 0.

Syntax

ISNULL(expression)

Parameter Values

Parameter Description
expression Required. The value to test

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Test whether an expression is NULL:

SELECT ISNULL("");
Try it Yourself »

Example

Test whether an expression is NULL:

SELECT ISNULL(350);
Try it Yourself »

Example

Test whether an expression is NULL:

SELECT ISNULL("Hello world!");
Try it Yourself »

❮ MySQL Functions