MYSQL - Multiple count in rows instead of columns

[Shuja Ali]

You are actually looking for Group By. A group By would give you result like this

State Count
MI 12
ID 15

Try this query

Select STATE, Count(STATE) From  TABLE Group By STATE