Skip to content

Instantly share code, notes, and snippets.

@bunnywong

bunnywong/gist:36bc0f1dc2cbcdcddb05

Last active August 29, 2015 14:16
Show Gist options
  • Save bunnywong/36bc0f1dc2cbcdcddb05 to your computer and use it in GitHub Desktop.
Save bunnywong/36bc0f1dc2cbcdcddb05 to your computer and use it in GitHub Desktop.
Download ZIP
Opencart - Status
Raw
gistfile1.sql
# Query penning status(1)
SELECT * FROM `oc_order`
WHERE (`order_id` BETWEEN 100 AND 200)
AND `order_status_id` = 1
ORDER BY `order_status_id`
# Update: penning status(1) ONLY
UPDATE oc_order SET order_status_id = 5
WHERE (`order_id` BETWEEN 100 AND 200)
AND `order_status_id` = 1
ORDER BY `order_status_id`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment