MySQL Searched CASE Expression — with examples
During many decision-making phases in programming code (conditional logic), there are times execution depends on several different factors. Multiple conditional tests are powerful and constraining, oftentimes requiring more than one test to be passed in order for program flow to proceed. For MySQL (and standard SQL in general) the CASE
expression is used for IF
/THEN
/ELSE
conditional logic.
The post, MySQL Simple CASE Expression – with examples, covered Simple CASE
queries which are essentially equality tests. MySQL Simple CASE
is but one variant of…