mysql 联合查询

查询部门编号>90或邮箱包含a的员工信息

SELECT *
FROM employees
WHERE department_id>90 OR email LIKE ‘%a%‘;

或

SELECT * FROM employees WHERE email LIKE ‘%a%‘
UNION
SELECT * FROM employees WHERE department_id>90

mysql 联合查询

标签：查询   like   str   dep   rtm   字段名   编号   信息   联合会