title: Mysql select grouping by part of a date field
body: <p>I have an application log table. I currently count number of actions per minute by using the following query</p>
  
  <pre><code>SELECT COUNT(id) 
  FROM application_log 
  WHERE activity_date LIKE '%2016-11-01 18:12%' AND activity_type = 'Full Invoice' AND status = 'Success'
  </code></pre>
  
  <p>Currently, I have to change each minute and rerun the query.</p>
  
  <p>Is there any way I can get the count per minute for a period of one hour? Or go further by getting the number of actions per hour for a day?</p>