title: MySQL compare DATE string with string from DATETIME field
body: <p>I have a question: Is it possible to select from a MySQL database by comparing one DATE string "2010-04-29" against strings that are stored as DATETIME (2010-04-29 10:00)?</p>
  
  <p>I have one date picker that filters data and I would like to query the table by the DATETIME field like this:</p>
  
  <pre><code>SELECT * FROM `calendar` WHERE startTime = '2010-04-29'"
  </code></pre>
  
  <p>...and I would like to get the row that has the DATETIME value of "2010-04-29 10:00".</p>
  
  <p>Any suggestions? Thanks.</p>