title: MySQL: Is there a way to update an entire table in one query?
body: <p>I need to update all the records of a table(shouldn't be over a 100 records). Each record will need to have a field updated with a different value.</p>
  
  <p>Am I going to have to make a query for each update or is there another way? I can't seem to figure out to do it at once</p>
  
  <p>Thanks for the help!</p>
  
  <p><strong>EDIT:</strong> To clarify, each field that i'm updating will contain a unique value that is determined on the client-side. So no other tables are involved.</p>