title: Getting records from MySQL based on a time window
body: <p>I want to count records based on a cut-off time. My cut-off time is midnight.</p>
  
  <p>So, when a user inserts a new record, I want to know how many records have been inserted between NOW() and my cut-off time (which would be 12:00AM today). I don't know to tell MySQL to dynamically go 12:00AM of today... basically, what I want to do is:</p>
  
  <p><code>SELECT COUNT(id) FROM myTable WHERE createdAt is between now and today's 12:00AM</code></p>