How To Use CASE Expression
How To Use CASE Expression? - MySQL FAQs - Introduction to SQL Basics
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
2007-05-11, 4286👍, 0💬
What is the version information in XML? “version” tag shows which version of XML is used.
Are risk constant through out the project ? * Never say that risk is high through out the project. R...
How do you override a defined macro? You can use the #undef preprocessor directive to undefine (over...
What are shared (VB.NET)/Static(C#) variables? Static/Shared classes are used when a class provides ...
Which bit wise operator is suitable for turning on a particular bit in a number? The bitwise OR oper...