Control Flow Functions: IF and CASE in MySQL

IF() Function

SELECT name, IF(salary > 50000, 'High', 'Low') AS salary_category FROM employees;

CASE Statement

SELECT name, 
  CASE 
    WHEN salary > 70000 THEN 'Excellent'
    WHEN salary > 50000 THEN 'Good'
    ELSE 'Average'
  END AS performance 
FROM employees;