SQL Help:MySQL Specific

[Virgosys Software]

Hi All,

I am facing difficulty in fetching records when encounterd with different
cases.

for example:

I want count of all the records from leads table where status = 0 , status
=1, status = 3....etc. This should happen in a single query, is it possible?

This is possible using DECODE function in Oracle. But in MySql, I could not
find any function that supports DECODE functionality given by oracle.

Could you please help me out.

TIA
Rajiv