title: Recent records by TIME field in MySQL
body: <p>I have a simple table that has a TIME column named <code>timeC</code> in the example below. I want to select all the records for which timeC is in the last five minutes. I have tried the following and many variations without success.</p>
  
  <pre><code>SELECT * FROM sample_schema.`exampleTable`
  WHERE MINUTE(TIMEDIFF(SELECT TIME(NOW())), `timeC`)&lt;5;
  </code></pre>
  
  <p>Note that the column is TIME, not DATETIME or TIMESTAMP.</p>
  
  <p>Suggestions?</p>