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
Bookmarks