optimizing mysql

http://www.karlrixon.co.uk/articles/sql/update-multiple-rows-with-different-values-and-a-single-sql-query/

source: http://stackoverflow.com/questions/4031814/what-is-the-fastest-way-to-update-thousands-rows-in-mysql