Collections:
IF() - Conditional Value Selection
How to conditionally select a value using the IF() function?
✍: FYIcenter.com
IF(cond, val1, val2) is a MySQL built-in function that returns the second argument if the first argument is TRUE, the third argument otherwise.
The first argument is treated as an integer and evaluated to TRUE if it is not 0. For example:
SELECT IF(2>1, 'yes', 'no'), IF(9, 'yes', 'no'); -- +----------------------+--------------------+ -- | IF(2>1, 'yes', 'no') | IF(9, 'yes', 'no') | -- +----------------------+--------------------+ -- | yes | yes | -- +----------------------+--------------------+ SELECT IF(TRUE, 'yes', 'no'), IF('TRUE', 'yes', 'no'), IF('100% TRUE', 'yes', 'no'); -- +-----------------------+-------------------------+------------------------------+ -- | IF(TRUE, 'yes', 'no') | IF('TRUE', 'yes', 'no') | IF('100% TRUE', 'yes', 'no') | -- +-----------------------+-------------------------+------------------------------+ -- | yes | no | yes | -- +-----------------------+-------------------------+------------------------------+ SELECT IF(NULL, 'yes', 'no'), IF('NULL', 'yes', 'no'); -- +-----------------------+-------------------------+ -- | IF(TRUE, 'yes', 'no') | IF('True', 'yes', 'no') | -- +-----------------------+-------------------------+ -- | yes | no | -- +-----------------------+-------------------------+
Reference information of the IF() function:
IF(cond, val1, val2): val Returns the second argument if the first argument is TRUE, the third argument otherwise. Arguments, return value and availability: cond: Required. The Boolean condition. val1, val2: Required. The values to be selected from. val: Return value. The selected value. Available since MySQL 4.0.
⇒ IFNULL() - Replacing NULL Value
⇐ GREATEST() - Finding the Greatest/Maximum Value
2023-12-19, 293🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...