this should work:
select NAME, sum(if(IF_PURCHASED='true',COUNT,0)),
sum(if(IF_PURCHASED='false', COUNT,0)) from TABLENAME group by NAME;
eva
-Original Message-
From: cengiz tahan [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 9:29 AM
To: [EMAIL PROTECTED]
Subject: Can I do
no.
You can do:
SELECT sum(length(Something)) FROM MyDB WHERE MyDB.Something LIKE 'this%'
But you will have to specify that for each field you want...then add them
all up to get the length.
Cal
http://www.calevans.com
-Original Message-
From: Jason Terry [mailto:[EMAIL PROTECTED]]