From: Graeme B. Davis
Date: March 1 2000 11:03pm
Subject: COUNTing
List-Archive: http://lists.mysql.com/mysql/29710
Message-Id: <039e01bf83d2$5f43c170$b16a2799@tows517>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Is there any way to do something like: (psuedocode follows)

SELECT count(medium='Phone'), count(medium='Email') FROM table GROUP BY
person

basically I want to accomplish:

SELECT count(medium) FROM table WHERE medium='Phone' GROUP BY person;
SELECT count(medium) FROM table WHERE medium='Email' GROUP BY person;

in one statement...

is this possible?


Thanks!

Graeme