getting count from the same column in a mysql table?

Viewed 12796

I wanted to a count of the same field for different values for example:

user{user_id, gender}

Gender can have obviously male or female :)

i want to get count for all the males and females i.e.

COUNT(male)   COUNT(female)  
   4               16

but im confused because they come from the same gender coloumn thanks

4 Answers
Related