title: Is MySQL now() interval in milliseconds possible?
body: <p>I'm trying to only select the rows within 500 MS but I'm not sure if this is even possible with just MySQL?</p>
  
  <p>My current code is:</p>
  
  <pre><code>$stmt = $mysqli-&gt;prepare('SELECT chat_user, chat_msg FROM chat_msg 
                            WHERE chat_id = ? 
                            AND chat_time &gt; (NOW() - INTERVAL 1 SECOND) 
                            AND chat_user != ?');
  </code></pre>
  
  <p>I was unable to insert that in a code block.</p>