title: Counting rows divided by conditions in one select
body: <p>This is what  basically my mysql-table looks like:</p>
  
  <pre><code>id  | A  |  B  
  -------------
  1 | bla  |  1
  2 | bla  |  2
  3 | bla  |  1
  4 | bla  |  1
  5 | bla  |  2
  6 | bla  |  2
  7 | bla  |  1
  </code></pre>
  
  <p>I wanna count how many rows do have 1 as B value and how many rows do have 2 as B value. Is it possible/does it make sense to do this in one SELECT statement?</p>
  
  <p>regards &amp;&amp; tia
    noircc</p>