Skip to content

Instantly share code, notes, and snippets.

@cavebatsofware

cavebatsofware/update_shipping_method.sql

Created February 8, 2013 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cavebatsofware/4739179 to your computer and use it in GitHub Desktop.
Save cavebatsofware/4739179 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update_shipping_method.sql
update order_details
set shipment_method_id = 'i2U12R'
where order_id in
(
select
order_id
from
orders
where
client_id = 'artkohlcom' and status <> 'Shipped' and status <> 'Cancelled'
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment