MySQL IFNULL() Function

Return the specified value IF the expression is NULL, otherwise return the expression:

SELECT IFNULL(NULL, "91xjr.com");

Definition and Usage

The IFNULL() function returns a specified value if the expression is NULL.

If the expression is NOT NULL, this function returns the expression.

IFNULL( expression, alt_value)

Parameter	Description
expression	Required. The expression to test whether is NULL
alt_value	Required. The value to return if expression is NULL

Works in:	From MySQL 4.0

Return the specified value IF the expression is NULL, otherwise return the expression:

SELECT IFNULL("Hello", "91xjr.com");

Return the specified value IF the expression is NULL, otherwise return the expression:

SELECT IFNULL(NULL, 500);