UPDATE numestaging.sales_flat_order SET base_discount_amount = CONCAT('-',base_discount_amount) WHERE `coupon_code` LIKE '%couponcode%' ORDER BY `entity_id`
UPDATE numestaging.sales_flat_order SET base_discount_amount = CONCAT('-',base_discount_amount) WHERE `base_discount_amount` > 0
SELECT * FROM sales_flat_order WHERE `base_discount_amount` > 0
Comments
Post a Comment
Feel Free To Ask...