Mysql or in UNION ALL
在没有索引的情况 or 和 in 会全盘扫描 用 EXPLAN 查看 type 为 all 而 UNION ALL type 为 ref
SELECT title FROM node WHERE type = 'spec_code' or type = 'supervisioncode';SELECT title FROM node WHERE type in ('spec_code','supervisioncode');
SELECT title FROM node WHERE type ='spec_code'
UNION ALL SELECT title FROM node WHERE type ='supervisioncode';