CASE Function in MySQL
The CASE Function in MySQL allows using conditional logic within the queries. It evaluates the conditions and returns a value when a condition is met (like an if-then-else statement).
It can be used with different statements like SELECT, WHERE, and ORDER BY clause based on its use and requirements.
Some features of MySQL CASE function are shown below:
- This function returns the statement in the else part if none of the stated conditions are true.
- This function returns NULL if none of the stated conditions are true and there is no ELSE part.
- This function comes under Advanced Functions.
- This function accepts two parameters namely conditions and results.
MySQL CASE() Function
MySQL CASE function is a conditional statement that returns a value when the first condition is met.
Once a condition is met, the CASE function does not check for other conditions. If no condition is met it returns the output in ELSE part.