select sum(status = 'pending' ) as numPending,
sum(status = 'active' ) as numActive,
sum(status = 'cancelled') as numCancelled
from <table>
ought to get you what you want.
--Pete
On Tue, May 13, 2003 at 03:36:24PM -0700, 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
