使用php mysql在列中计数和显示每个重复的值

Question

我希望使用php mysql在下表中的列中计数和显示每个重复的值。

name  
AAA
BBB
BBB
BBB
AAA
CCC

结果应如下所示

AAA-2
BBB-3
CCC-1

Answer 1

select name, count(name) as count from table_name group by name

Answer 2

你需要：

select name,count(1) from yourtable group by name

如果您需要输出连字符(-)

select concat(name,'-',count(1)) from yourtable group by name

Answer 3

尝尝这个,

select name, count(*) from <table> group by name;