mysql条件in

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

SELECT * FROM employees
WHERE department_id IN (1, 2, 3);

SELECT * FROM employees
WHERE department_id IN (SELECT id FROM departments WHERE status = 'active');

CREATE TEMPORARY TABLE temp_departments (id INT);
INSERT INTO temp_departments (id) VALUES (1), (2), (3);

SELECT * FROM employees
JOIN temp_departments ON employees.department_id = temp_departments.id;

SELECT * FROM employees e
WHERE EXISTS (SELECT 1 FROM departments d WHERE d.id = e.department_id AND d.status = 'active');