MySQL command to count the number of entries for a group

SELECT <i>field_to_count</i>, count(id) FROM `<i>table_name</i>` group by <i>field_to_count</i>