MySQL ISNULL() Function
ExampleGet your own SQL Server
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 |
---|