http://topic.csdn.net/u/20110310/13/3279054f-5022-4fac-baa7-d194f5335ba0.html
http://www.rosoo.net/a/201103/11043.html
http://topic.csdn.net/u/20080921/18/718f167e-e030-439d-a206-b2dc3dc99a3f.html?1273378877
http://www.rosoo.net/a/201103/11043.html
http://topic.csdn.net/u/20080921/18/718f167e-e030-439d-a206-b2dc3dc99a3f.html?1273378877
http://www.cnblogs.com/yahle/archive/2007/08/08/848060.html
http://www.karlrixon.co.uk/articles/sql/update-multiple-rows-with-different-values-and-a-single-sql-query/
http://stuporglue.org/update-multiple-rows-at-once-with-different-values-in-mysql/
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69902
you can use this query:
UPDATE categories
SET display_order = CASE id
WHEN 1 THEN 3
WHEN 2 THEN 4
WHEN 3 THEN 5
END,
title = CASE id
WHEN 1 THEN 'New Title 1'
WHEN 2 THEN 'New Title 2'
WHEN 3 THEN 'New Title 3'
END
WHERE id IN (1,2,3)