SQL question

[Marc Antony Vose]

Hi there...

is there an way in mysql to select all the distinct items in a table 
and get a count of each?

this has me stumped.

i'd like output like:

United States | 150
Belgium | 25
UK | 15


and so on.

cheers,

-- 
Marc Antony Vose
http://www.suzerain.com/

Into every tidy scheme for arranging the pattern of human life, it is 
necessary to inject a certain dose of anarchism.
-- Bertrand Russell