MySQL-联合查询

引入

SELECT *
FROM `employees`
WHERE `department_id`>90
OR `email` LIKE '%a%'

利用union来做

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

union语法：