Example

Compare two expressions:

SELECT NULLIF(25, 25);

Definition and Usage

The NULLIF() function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned.

Syntax

NULLIF(expr1, expr2)

Parameter Values

Parameter Description
expr1, expr2 Required. The two expressions to be compared

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Compare two expressions:

SELECT NULLIF(25, "Hello");

Example

Compare two expressions:

SELECT NULLIF("Hello", "world");

Example

Compare two expressions:

SELECT NULLIF("2017-08-25", "2017-08-25");


Login
ADS CODE