General MySQL Oracle SQL Server

NULLIF() - NULL on Equal Values

Q

How to generate NULL with equal values using the NULLIF() function?

✍: FYIcenter.com

A

NULLIF(val1, val2) is a MySQL built-in function that returns NULL if the first argument equals the second, the first argument otherwise. For example: 

SELECT NULLIF('yes', 'yes'), NULLIF('yes', 'no');
  -- +----------------------+---------------------+
  -- | NULLIF('yes', 'yes') | NULLIF('yes', 'no') |
  -- +----------------------+---------------------+
  -- | NULL                 | yes                 |
  -- +----------------------+---------------------+

Reference information of the NULLIF() function: 

NULLIF(val1, val2): val
  Returns NULL if the first argument equals the second, 
  the first argument otherwise.

Arguments, return value and availability:
  val1, val2: Required. The values to be selected from.
  val: Return value. NULL if val1=val2, val1 otherwise.
  Available since MySQL 4.0.

 

⇒ RELEASE_ALL_LOCKS() - Release All Locks

⇐ NAME_CONST() - PS Thread ID of Given Connect

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References

2023-12-19, 1170🔥, 0💬

General MySQL Oracle SQL Server