MySQL

MySQL command to count the number of entries for a group

SELECT field_to_count, count(id) FROM `table_name` group by field_to_count