mysql分类统计数量

1:SELECT SUM(总藏书量),SUM(管内剩余) FROM `藏书信息` GROUP BY 入库时间

2:SELECT SUM(总藏书量)/count(总藏书量),SUM(管内剩余)/count(管内剩余) FROM `藏书信息` GROUP BY 入库时间

用全文索引，把字段的索引设为fulltext

select count(*) from table where MATCH(field1) AGAINST('aaa')

select count(*) from table where MATCH(field1) AGAINST('bbb')

select count(*) from table where MATCH(field1) AGAINST('ccc')

select count(*) from table where MATCH(field1) AGAINST('ddd')

目前只能想到分别查询了

---