A mySQL query needed

I have a table like this:

field1
-----
A
A
B
C
D
D
D
E

I want to make a query to produce a result like this:


A 2
B 1
C 1
D 3
E 1

that means I want to DISTRINCT field1 and count total row for particular letter.
What will be the query?

 

select field1, count(field1) as totals from table1 group by field1;

PHP:

 

sw0rdfi5h ,

Thank You