关于一条语句返回多个count值
SELECT COUNT(time) FROM `aaaa` WHERE `time` >= '2016/1/1 0:00:00' AND `time` <= '2016/7/1 23:59:59' and time like '% 13:%';SELECT COUNT(time) FROM `aaaa` WHERE `time` >= '2016/1/1 0:00:00' AND `time` <= '2016/7/1 23:59:59' and time like '% 14:%';
SELECT COUNT(time) FROM `aaaa` WHERE `time` >= '2016/1/1 0:00:00' AND `time` <= '2016/7/1 23:59:59' and time like '% 18:%';
这三条语句怎么能合成一个语句呢? 其实是前边的条件都是一样的,就是最后那个不一样