Example
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 |
|---|