MySQL NULLIF() Function
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 |
---|