select field1, count(*)
from mytable
group by field1