List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:May 13 2003 11:08pm
Subject:Re: count()
View as plain text  
Unless I'm having thinking problems as well,

         select status, count(*) group by status

should work.

         steve


At 03:36 PM 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'
>...
>
>mysql,sql

+------------------------------------------------------------------------+
| Steve Edberg                                      sbedberg@stripped |
| Database/Programming/SysAdmin                            (530)754-9127 |
| University of California, Davis             http://pgfsun.ucdavis.edu/ |
+---------------------- Gort, Klaatu barada nikto! ----------------------+

Thread
count()Eric Anderson14 May
  • Re: count()Jeff Shapiro14 May
  • Re: count()Dan Nelson14 May
  • Re: count()Paul DuBois14 May
  • RE: count()Jennifer Goodie14 May
  • Re: count()Keith C. Ivey14 May
  • Re: count()(Pete Harlan)14 May
  • Re: count()Matt Silva15 May
Re: count()Steve Edberg14 May
  • Re: count()CR14 May
Re: count()Steve Edberg14 May
RE: count()Eric Anderson14 May
RE: count()Mike Hillyer14 May