title: getting count from the same column in a mysql table?
body: <p>I wanted to a count of the same field for different values for example:</p>
  
  <blockquote>
    <p>user{user_id, gender}</p>
  </blockquote>
  
  <p>Gender can have obviously male or female :)</p>
  
  <p>i want to get count for all the males and females i.e.</p>
  
  <pre><code>COUNT(male)   COUNT(female)  
     4               16
  </code></pre>
  
  <p>but im confused because they come from the same <code>gender coloumn</code> thanks</p>