COALESCE() - Finding First Non-NULL Value

Q

How to find the first non-NULL value from a list using the COALESCE() function?

✍: FYIcenter.com

A

COALESCE(val1, val2, ...) is a MySQL built-in function that returns the first non-NULL value from a given list of values. For example:

SELECT COALESCE(NULL, 'FYI', NULL, 3.14);
  -- +-----------------------------------+
  -- | COALESCE(NULL, 'FYI', NULL, 3.14) |
  -- +-----------------------------------+
  -- | FYI                               |
  -- +-----------------------------------+

Reference information of the COALESCE() function:

COALESCE(val1, val2, ...): val
  Returns the first non-NULL value from a given list of values.

Arguments, return value and availability:
  val1, val2, ...: One or more values to be examined.
  val: Return value. The first non-NULL value.
  Available since MySQL 4.0.

⇒ CONVERT() - Character Set Conversion

⇐ CAST() - Casting Expression to Value

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References

2026-03-22, 2005🔥, 0💬

JSON_TABLE() - Inline Table with JSON Array
How to create an inline table with a JSON Array using the JSON_TABLE() function? JSON_TABLE(json, path COLUMNS (column_list) AS alias) is a MySQL built-in function that creates an inline table by parsing JSON array members. For example: the following statement creates a 1-column table with string me... 2024-11-23, 2279🔥, 0💬

JSON_VALUE() - Converting JSON Value
How to convert a JSON value to a given MySQL data type using the JSON_VALUE() function? JSON_VALUE(json, path RETURNING type on_empty on_error) is a MySQL built-in function that converts a JSON value to a given MySQL data type. The input JSON value can be a member of a parent JSON array or object. F... 2024-11-23, 2188🔥, 0💬

INET_NTOA() - IP Address Number to String
How to convert an IP address from number format to string using the INET_NTOA() function? INET_NTOA(int) is a MySQL built-in function that converts an IP address from number format to string. It uses the following conversion formula: INET_NTOA(int) = 'p 1 .p 2 .p 3 .p 4 ' where: p 1 = (int>&a... 2026-04-13, 2159🔥, 0💬

INET_ATON() - IP Address String to Number
How to convert an IP address from string format to number using the INET_ATON() function? INET_ATON(ip) is a MySQL built-in function that converts an IP address from string format to number. It uses the following conversion formula: INET_ATON('p 1 .p 2 .p 3 .p 4 ') = INET_ATON(p 1 ×256 3 + p 2 ×256 ... 2026-07-13, 2074🔥, 0💬

COALESCE() - Finding First Non-NULL Value
How to find the first non-NULL value from a list using the COALESCE() function? COALESCE(val1, val2, ...) is a MySQL built-in function that returns the first non-NULL value from a given list of values. For example: SELECT COALESCE(NULL, 'FYI', NULL, 3.14); -- +----------------------------- ------+--... 2026-03-22, 2006🔥, 0💬

INET6_ATON() - IPv6 Address String to Number
How to convert an IPv6 address from string format to number using the INET6_ATON() function? INET6_ATON(ip) is a MySQL built-in function that converts an IPv6 address from string format to number. But an IPv6 number is too big to be represented in decimal digits. So it is stored as a byte sequence, ... 2026-04-13, 1940🔥, 0💬

BIN() - Converting Integer to Binary String
How to convert an integer to a binary string using the BIN() function? BIN(int) is a MySQL built-in function that converts an integer to binary string. For example: SELECT BIN(1), BIN(2), BIN(4), BIN(8), BIN(16), BIN(1024); -- +--------+--------+--------+-- ------+---------+------------- +-- | BIN(1)... 2024-11-23, 1911🔥, 0💬

GREATEST() - Finding the Greatest/Maximum Value
How to find the greatest (maximum) value of a given list of values using the GREATEST() function? GREATEST(val1, val2, ...) is a MySQL built-in function that returns the greatest (maximum) value of a given list of values. For example: SELECT GREATEST(70, 89, 73, 99, 101, 110, 116, 101, 114); -- +---... 2026-07-13, 1904🔥, 0💬

CAST() - Casting Expression to Value
How to cast an expression to a value of the given data type using the CAST() function? CAST(exp AS type) is a MySQL built-in function that casts an expression to a value of the given data type. For example: SET @exp = '-1.99 USD'; SELECT @exp, CAST(@exp AS SIGNED INTEGER), CAST(@exp AS UNSIGNED INTE... 2026-03-22, 1769🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.