SQL Question: COUNT(column)

[gamew0rld]

I have a field in my MySQL database called category. The values of this field are numbers ranging from 1 to 9 (each represents a different category). I want to count the number of rows that have a value for each number, 1 through 9. Is there a way I can use 1 query to do this or do I have to use 9 separate ones?

Thanks in advance,
Joe

[kevinc]

select category,count(*) as hits from tablename group by category