mysql - thinkphp查询一个字段并查询该字段的每个值出现的次数

Question

感觉自己好笨啊。。。

Answer 1

M($table)->field('field,count(field)')->group('field')->select()

Answer 2

不要气馁
多熟悉下SQL就行了，和thinkPHP无关

select field,count(field) from table

Answer 3

select field,count(field) as ct from (select field from field) as tb group by field order by field;不知对否，自行测试

Answer 4

select field, count(field) from table group by field;
SQL GROUP BY