title: group by based on part of a column value in mySql
body: <p>I have a mySql  table call details. details table is having a column call date which is having date like <code>2015-02-01</code>. There can be multiple rows from a same date.</p>
  
  <p>I want to find how many rows <code>COUNT()</code> it contains for each month of the year.</p>
  
  <p>for example,</p>
  
  <pre><code>'568', '192.168.1.100', '790', '1.00', '2014-11-14'    
  '569', '192.168.1.100', '780', '1.00', '2014-11-14'  
  '699', '192.168.1.100', '780', '1.00', '2014-11-16'
  '767', '192.168.1.102', '780', '1.00', '2014-12-15'   
  '768', '192.168.1.102', '780', '1.00', '2014-12-15'
  </code></pre>
  
  <p>this should give COUNT like:</p>
  
  <pre><code> '2014-11-' as 3
   '2014-12-' as 2
  </code></pre>
  
  <p>How can i do it using a sql select query.</p>