title: MySQL select specific date from datetime
body: <p>I'm trying to setup a mysql select query based on a given date in a datetime column. Something like:</p>
  
  <pre><code>SELECT DATE_FORMAT(colName, '%Y-%m-%d') WHERE..
  </code></pre>
  
  <p>But I'm unsure on how to do this correctly. I'm using php to do this.</p>