Collections:
Using CASE Expression in MySQL
How To Use CASE Expression in MySQL?
✍: FYIcenter.com
There are 2 ways to use the CASE expression. The first way is to return one of the predefined values based on the comparison of a given value to a list of target values. The second way is to return one of the predefined values based on a list of conditions. Here is the syntax of both types of CASE expressions:
CASE value WHEN target_value THEN result WHEN target_value THEN result WHEN target_value THEN result ... ELSE result END CASE WHEN condition THEN result WHEN condition THEN result WHEN condition THEN result ... ELSE result END
The tutorial exercise below gives two good examples:
SELECT CASE 'Sun' WHEN 'Mon' THEN 'Open' WHEN "Fri" THEN "Open" ELSE 'Closed' END FROM DUAL; Closed SELECT CASE WHEN HOUR(CURRENT_TIME())<9 THEN 'Closed' WHEN HOUR(CURRENT_TIME())>17 THEN 'Closed' ELSE 'Open' END FROM DUAL; Closed
⇒ Introduction to Date and Time Handling in MySQL
⇐ Using Regular Expression with REGEXP in MySQL
2018-03-24, 1575🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...