mysql中写判断

SELECT id, name, 
       CASE department
           WHEN 'HR' THEN 'HUMAN RESOURCES'
           WHEN 'IT' THEN 'INFORMATION TECHNOLOGY'
           ELSE 'OTHER'
       END AS department_name
FROM employees;

DELIMITER //

CREATE PROCEDURE GetEmployeeDetails(IN emp_id INT)
BEGIN
    DECLARE emp_department VARCHAR(255);
    
    SELECT department INTO emp_department FROM employees WHERE id = emp_id;
    
    IF emp_department = 'HR' THEN
        SELECT 'HUMAN RESOURCES' AS department_name;
    ELSEIF emp_department = 'IT' THEN
        SELECT 'INFORMATION TECHNOLOGY' AS department_name;
    ELSE
        SELECT 'OTHER' AS department_name;
    END IF;
END //

DELIMITER ;