table column issues

[kehers]

i av a table with a column containing categories some addresses belong to, occuring a number of times. i'd however luv to get each distinct category in the column with their number of occurence. As in something like this:
---------------+-----
CategoryNameA | 5
---------------+-----
CategoryNameB | 10
...
and so on.
How do i go about it?

 

[cLFlaVA]

use this:

select category_name
           , count(1)
        from table_name
    group by category_name

*cLFlaVA
----------------------------
[tt]I already made like infinity of those at scout camp...[/tt]
beware of active imagination: [URL unfurl="true"]http://www.coryarthus.com/[/url]