多表模糊匹配统计查询结果数量
select sum(a.b) as num from (select count(*) as b from dr_1_news where title like "%出租%" OR keywords like "%出租%" OR content like "%出租%" union all select count(*) as b from dr_1_qcp where title like "%出租%" OR keywords like "%出租%" OR content like "%出租%" union all select count(*) as b from dr_1_zhuanr where title like "%出租%" OR keywords like "%出租%" OR content like "%出租%" union all select count(*) as b from dr_1_tix where title like "%出租%" OR keywords like "%出租%" OR content like "%出租%" union all select count(*) as b from dr_1_zhin where title like "%出租%" OR keywords like "%出租%" OR content like "%出租%" union all select count(*) as b from dr_1_wend where title like "%出租%" OR keywords like "%出租%" OR content like "%出租%") AS a
