Sort Queries

sorting.sql

#Forwarding 
#ex. : from = 1, to = 5
UPDATE table_name SET order_field = order_field - 1
WHERE order_field > {from}
AND order_field <= {to}

#Backward
#ex. from = 5, to = 1
UPDATE table_name SET order_field = order_field + 1
WHERE order_field >= {to}
AND order_field < {from}

#Run this after both update query:
UPDATE table_name SET order_field = {to}
WHERE id_field = {from_row_id}