title: Ignoring locked row in a MySQL query
body: <p>I have one table that is read at the same time by different threads. </p>
  
  <p>Each thread must select 100 rows, execute some tasks on each row (unrelated to the database) then they must delete the selected row from the table.</p>
  
  <p>rows are selected using this query:</p>
  
  <pre><code>SELECT id FROM table_name FOR UPDATE;
  </code></pre>
  
  <p>My question is: How can I ignore (or skip) rows that were previously locked using a select statement in MySQL ?</p>