title: How to manage working/open project records in mysql with more than one user?
body: <p>I have a few ideas, but thought Im likely touching on a common topic (though I didnt find it)...</p>
  
  <p>Weekly we have about 500 records a single user has been processing, we use pagination set to single record, when the record is updated the page reloads the next record. Works simple and easy. -<em>Codeigniter, PHP</em>.</p>
  
  <p>Ahh, but now I want multiple users to work on the same group of records without grabbing the same record, until they are exhausted, <em>the records not the users.</em></p>
  
  <p>Is there a general convention for doing this?</p>
  
  <p>off the cuff, I'd likely change the <code>status</code> of the working record to <code>pending</code> as its being loaded. Am I missing something? Is there a better/cleaner way?</p>