Counting distinct records
I have a table with a field for category names.
I would like to list the category name in groups maybe with distinct in the mysql table and them have a count result, like
cat1 50
cat2 25
cat3 500
etc
Can you say how this is carried out please?
Many thanks
John