Need to write a SQL script

[djmonkey1]

Hey-

 

I'm just looking for a quick and easy way to update old orders in my database to all be marked as "shipped". A SQL command seems like the easiest way, but I'm no good with SQL commands.

 

All it would have to say is in the table orders_status_history, wherever the orders_id falls in a range from 8-88, then the orders_status_id would be changed to 3.

 

Thanks in advance!

Stew

[wheeloftime]

Hey-

 

I'm just looking for a quick and easy way to update old orders in my database to all be marked as "shipped". A SQL command seems like the easiest way, but I'm no good with SQL commands.

 

All it would have to say is in the table orders_status_history, wherever the orders_id falls in a range from 8-88, then the orders_status_id would be changed to 3.

 

Thanks in advance!

Stew

 

Something like this (untested :rolleyes: )

UPDATE `orders_status_history` SET `orders_status_id`= 3 WHERE `orders_id` >= 8 AND `orders_id`<= 88

[djmonkey1]

Something like this (untested :rolleyes: )

UPDATE `orders_status_history` SET `orders_status_id`= 3 WHERE `orders_id` >= 8 AND `orders_id`<= 88

 

That almost did it, but I was asking to do the wrong thing! What I really should have asked for was this:

 

UPDATE orders SET orders_status= 3 WHERE orders_id >= 8 AND orders_id<= 88;

 

But now I'm happy! Thanks!