MySQL NULLIF() Function
THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULAR XML MORE FORUM EXAMPLES REFERENCES

MySQL NULLIF() Function

❮ MySQL Functions

Example

Compare two expressions:

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

Definition and Usage

The NULLIF() function compares two expressions.

If expr1 and expr2 are equal, the NULLIF() function returns NULL. Otherwise, it returns expr1. 

Syntax

NULLIF(expr1, expr2)

Parameter Values

Parameter Description
expr1, expr2 Required. The two expressions that will 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