Collections:
IFNULL() - Replacing NULL Value
How to substitute a NULL value with a replacement value using the IFNULL() function?
✍: FYIcenter.com
IFNULL(val1, val2) is a MySQL built-in function that returns the second argument if the first argument is NULL, the first argument otherwise. For example:
SELECT IFNULL(NULL, 'replacement'), IFNULL('original', 'replacement'); -- +-----------------------------+-----------------------------------+ -- | IFNULL(NULL, 'replacement') | IFNULL('original', 'replacement') | -- +-----------------------------+-----------------------------------+ -- | replacement | original | -- +-----------------------------+-----------------------------------+
Reference information of the IFNULL() function:
IFNULL(val1, val2): val Returns the second argument if the first argument is NULL, the first argument otherwise. Arguments, return value and availability: val1, val2: Required. The values to be selected from. val: Return value. The selected value. Available since MySQL 4.0.
⇒ INET_ATON() - IP Address String to Number
⇐ IF() - Conditional Value Selection
2023-12-19, 253🔥, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...