mysql - sql 语句，如何求一个表中，某个字段重复出现的次数，我不熟sql语句。

Question

如图:我需要统计 issue=3 的每个用户记录出现的次数，我不熟sql一些函数，求教应该用哪个？

应该得出：
峰 = 3
骄傲 = 1
青枫 = 3
小小= 1

Answer 1

SELECT count(index), user FROM table WHERE issue=3 GROUP BY user;

Answer 2

select [user], count(*)
from YourTable
where issue='3'
group by [user]

Answer 3

select user, count(1) 
from table_name 
where issue = 3
group by user

直接分类count就可以