help to query this one

[PHPycho]

Hello forums !!
I would like to
For example:
table "table_name" contains fields like
"field1" which contains only values "A","B"
"field2" which contains only values "X","Y"
To find the no of A in field1, no of B in field1 , no of X in field2, no of Y in field2 we can perform independent query as:

$sql1 = "SELECT count(field1) AS no_of_A FROM table_name WHERE field1='A'";
$sql2 = "SELECT count(field1) AS no_of_B FROM table_name WHERE field1='B'";
$sql3 = "SELECT count(field2) AS no_of_X FROM table_name WHERE field1='X'";
$sql4 = "SELECT count(field2) AS no_of_Y FROM table_name WHERE field1='Y'";

But I want to perform above queries in one......
I would like to have somewhat

$sql = "SELECT count(field1 = 'A') AS no_of_A, count(field1 = 'B') AS no_of_B, count(field2 = 'X') AS no_of_X),count(field2 = 'Y') AS no_of_Y FROM table_name WHERE field1='Y'"

I know above query doesnt work..i am just telling what i want to do..
and thats the very challenging for me..
Any comments and suggestions are warmly welcome
I am awaiting for your help.
Thanks in advance to all of you

[bogu]

Different conditions means different selects, but you can use UNION ...

[Roger_Ramjet]

What you are looking for is Group By and Aggregate Functions.

Now you could get all 4 counts from the 2 different fields by using WITH ROLLUP but I don't think it is worth the effort. Just do 2 queries, either alone or in a UNION.

[Lars_Berg]

select sum(case when column1 = 'A' then 1 else 0 end) noA,
       sum(case when column1 = 'B' then 1 else 0 end) noB,
       sum(case when column2 = 'X' then 1 else 0 end) noX,
       sum(case when column2 = 'Y' then 1 else 0 end) noY
  from t
 where column1 in ('A','B')
    or column2 in ('X','Y')

[Roger_Ramjet]

Bit of an overkill isn't it Lars?

[Sxooter]

Actually, I'm willing to bet that Lar's query is the most efficient way of doing it.