title: MySQL date comparison function
body: <p>In my table dates are stored in the format <code>"2010-08-26 09:00:00"</code> so yyyy-mm-dd. I'd like to select all fields that have a date field that is "today", so between <code>2010-08-26 00:00:01</code> and <code>2010-08-26 23:59:59</code>.</p>
  
  <p>Just using larger and smaller than operators does not work, does MySQL have some built in date comparison functions that can do this?</p>
  
  <p>EDIT: I should have mentioned dates are stored as <code>datetime</code> fields</p>