SQL find and replace

[gloerick]

Hello, I have changed the order status line of shipped, deliverd and such, so now of course all my deliverd order that were a #6 now need to be a 20 so all my delivered orders are showing.

how do I do a find and replace with sql in the DB ?

I did a find for all order_status = 6 in the OREDER table and found them, now I want to Run SQL query/queries on database and change all the order_status from 6 to 20

or I will be editing alot of orders :-( to get the status back to a delived #20

SELECT * FROM `orders_status` WHERE 1

[gloerick]

on the orders table I need to find and replace the orders_status from a number 6 to number 20

[RodG]

on the orders table I need to find and replace the orders_status from a number 6 to number 20

UPDATE `orders` SET `orders_status`= 20 WHERE  `orders_status`= 6 ;

Usual rules apply. Backup first.

Cheers
Rod

[wcbutler]

UPDATE `orders` SET `orders_status`= 20 WHERE  `orders_status`= 6 ;

Usual rules apply. Backup first.

Cheers
Rod

This thread was helpful for my needs in 2022. I ended up doing:

UPDATE `orders` SET `orders_status`= 3 WHERE `orders_status`= 2 ;
which updated any processing to delivered

I then changed two money orders I was waiting on to update status (4) in the UI
then did
UPDATE `orders` SET `orders_status`= 3 WHERE `orders_status`= 1 ;
to process any pending money orders

And then I manually moved the two status 4 back to status 1.

Before I did any of this I did one order to processing that I get the email to make sure I didn't get an email when I did the SQL change (obviously not but I'm changing 10k orders so being careful) and it did not email me as I had thought - UPDATE `orders` SET `orders_status`= 3 WHERE `orders_id`= 1 ;

[swguy]

Thanks for sharing your success!