title: How to compare timestamp dates with date-only parameter in MySQL?
body: <p>In a SQL statement, how do I compare a date saved as TIMESTAMP with a date in YYYY-MM-DD format?</p>
  <p>Ex.: <code>SELECT * FROM table WHERE timestamp = '2012-05-25'</code></p>
  <p>I want this query returns all rows having timestamp in the specified day, but it returns only rows having midnight timestamp.</p>
  <p>thanks</p>