Re: count()

[Paul DuBois]

At 15:36 -0700 5/13/03, Eric Anderson wrote:
>I'm not sure if I'm just having problems thinking today but if you've
>got a field:
>
>status enum('pending','active','cancelled') NOT NULL default 'pending'
>
>and you want to get a total of each the entries, is there any way to do
>it in one pass, as opposed to:
>
>select count(*) from <table> where status='pending'
>select count(*) from <table> where status='active'
>...

SELECT status, COUNT(*) FROM tbl_name GROUP BY status;

-- 
Paul DuBois
http://www.kitebird.com/
sql, query