SQL command to update order status ?

[Akasashasha]

Dears,

I would like to have an SQL command that enable me to update all orders to a new status.
I think it would be something like :
UPDATE order status SET order status = 3 (3 being shipped).
Please corretc the above SQL command or give me a right one to do this.

Thank you

Kind regards

Aka

[Akasashasha]

...humm ... no answer ?

[Get Em Fast]

It's not quite that easy, as the order status affects other tables, as well. Take a look at THIS THREAD. Be sure to pay close attention to what Dr.Byte has to say about this.