THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL NULLIF() Function

❮ MySQL Functions

Example

Compare two expressions:

SELECT NULLIF(25, 25);
Try it Yourself »

Definition and Usage

The NULLIF() function returns NULL if two expressions are equal, otherwise it returns the first expression. 

Syntax

NULLIF(expr1, expr2)

Parameter Values

Parameter Description
expr1, expr2 Required. Two expressions to be compared

Technical Details

Works in: MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

More Examples

Example

Compare two expressions:

SELECT NULLIF(25, "Hello");
Try it Yourself »

Example

Compare two expressions:

SELECT NULLIF("Hello", "world");
Try it Yourself »

Example

Compare two expressions:

SELECT NULLIF("2017-08-25", "2017-08-25");
Try it Yourself »

❮ MySQL Functions