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, 267🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...