title: MySql UNION for UPDATE
body: <p>Is there a way to update multiple rows with different values for each row using a single SQL query? I have to update one colum in many rows with different data. Using individual update queries for each row seems excessive so if it's possible I would like to consolidate this process into a single SQL statement or at least reduce the number of queries required.</p>
  
  <p>I am using PHP with the Zend framework and MySql.</p>