My_Sql selecting from SAME Field

[Anon]

Hello All, I have a table with a Result Field that contains the values 1, 2, 3, 4 Where 1 = Not Tested, 2= Passed, 3= Blocked, and 4= Failed. Is it possible to use a single SELECT query to count the number of 1's, 2's, 3's, and 4's from the SAME FIELD and return them all as a single row? Thanks.

[bastien]

select count(result) from table
group by result

hth
bastien