title: MySQL Select Date Equal to Today (having datetime as the data type)
body: <p>I'm trying to run a mysql select statement where it looks at today's date and only returns results that signed up on that current day. I've currently tried the following, but it doesn't seem to work.</p>
  
  <pre><code>SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d') 
      FROM users 
      WHERE users.signup_date = CURDATE()
  </code></pre>
  
  <p>I've modified my <code>SELECT</code> statement to this, thanks guys.</p>
  
  <p><code>SELECT id FROM users WHERE DATE(signup_date) = CURDATE()</code></p>