MySQL Reorder rows

Started by 蜃気楼 March 13th, 2009 7:09 AM
  • 1085 views
  • 8 replies
Seen February 27th, 2010
Posted October 20th, 2009
246 posts
15.9 Years
How to reorder two rows in a MySQL table from this:
[ID]
[1]
[2]
[3]
[4]


into
[ID]
[1]
[2]
[4]
[3]


I tried many queries, and it does not work, can someone help me?
Please do not say "It is impossible", because it wastes time.