mysql去重

table
  id name
  1 a
  2 b
  3 c
  4 c
  5 b

 

select *, count(distinct name) from table group by name

结果:

  id name count(distinct name)
  1 a 1
  2 b 1
  3 c 1

 

或则

group_concat(distinct name)配合group by name