bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL ISNULL() Function

Example

SELECT ISNULL(NULL);

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

ParameterDescription
expressionRequired. The value to test

Technical Details

Works in:From MySQL 4.0

Previous

MySQL IFNULL() Function

Next

MySQL LAST_INSERT_ID() Function