title: Mysql DATE_SUB(NOW(), INTERVAL 1 DAY) 24 hours or weekday?
body: <p>I am trying to get the total amount of registered users per day. At the moment I am using this:</p>
  <pre><code>$sql = &quot;SELECT name, email FROM users WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) &lt; lastModified&quot;
  </code></pre>
  <p>But I am not sure if this works per day or per 24 hours?</p>
  <p>For example, a user who registered 22 hours ago shouldn't be returned. I just want the user of today(=Tuesday).</p>