title: Select updated rows in mysql
body: <p>Is there simple way to select updated rows?</p>
  
  <p>I'm trying to store timestamp each time I am read row to be able to delete data that was not readed for a long time.</p>
  
  <p>First I tried execute <code>SELECT</code> query first and even found little bit slow but simple solution like  </p>
  
  <pre><code> UPDATE foo AS t, (SELECT id FROM foo WHERE statement=1)q
   SET t.time=NOW() WHERE t.id=q.id
  </code></pre>
  
  <p>but I still want to find a normal way to do this.</p>
  
  <p>I also think that updating time first and then just select updated rows should be much easier, but I didn't find anything even for this</p>