title: MySQL Query not returning any results
body: <p>I'm struggling to understand why my query isn't returning any results, please could you take a look and let me know what I'm doing wrong:</p>
  
  <pre><code>SELECT * FROM sys_online_users WHERE last_active BETWEEN NOW() AND DATE_SUB(NOW(), INTERVAL 10 SECOND) 
  </code></pre>
  
  <p>What I am trying to achieve is to show which users have been active within  the last 10 seconds or any other time interval. However when I run the query I get no results, despite knowing that I have got updates in my table between the specified time range.</p>