SWAP two rows by swapping its ID.
For example, I will swap ID 3 and ID 4:
[ID] [NAME]
[2][two]
[3][three]
[4][four]
swap row 3 and 4:
[ID] [NAME]
[2][two]
[4][four]
[3][three]
Is adding the OrderPriority column the only way?
This is completely unrelated to ORDER BY, and I googled other forums, and they also said about ORDEY BY stuff.