title: MySQL How to SELECT data from table which recorded today?
body: <p>Use PHP and MySQL. In my table, there is date field (datetime) recorded by NOW() sql function. Example value of data in this field is    <strong>2010-10-07 10:57:36</strong>. How can I SELECT all data which day-month-year is today. I try to use code as below:</p>
  
  <pre><code>  SELECT * FROM table WHERE date=????
  </code></pre>