Change all orders from status 'x', to status 'y'.

[swguy]

Make a db backup, then:

UPDATE orders SET orders_status = '3' WHERE orders_status = '5';
UPDATE orders_status_history SET orders_status = '3' WHERE orders_status = '5';

If the number of orders with status 5 is small, though, you might just do this by hand so you could make a status update note about the change you're making. To determine the number of orders in this state, do

SELECT COUNT(*) FROM orders WHERE orders_status = '5';