Skip to content

Instantly share code, notes, and snippets.

@vojtagrec

vojtagrec/cleanup-dev1.sql

Forked from hornofj/gist:4269711
Last active December 18, 2015 00:29
Show Gist options
  • Save vojtagrec/5697091 to your computer and use it in GitHub Desktop.
Save vojtagrec/5697091 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cleanup-dev1.sql
UPDATE gp_customer_entity SET email='[email protected]' WHERE email NOT LIKE '%mhdirekt%' AND email NOT LIKE '%keyup%' AND email NOT LIKE '%grec.cz';
UPDATE gp_sales_flat_order_address SET email=NULL;
UPDATE gp_sales_flat_order SET customer_email=NULL;
UPDATE gp_core_config_data
SET value = REPLACE(value, 'www', 'dev1')
WHERE path LIKE '%base_url';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment