Tag / sql

-- get saved credit card owner select value from sales_order_entity_varchar where attribute_id = 282 and entity_id in ( select entity_id from sales_order_entity_varchar where attribute_id = 280 and value != "" ); -- erase credit card data by order id SET @orderId = '100000013'; UPDATE sales_order_entity_varchar SET VALUE = NULL WHERE entity_id = ( SELECT entity_id FROM sales_order_entity WHERE entity_type_id =14 AND parent_id = ( SELECT entity_id FROM sales_order WHERE increment_id = @orderId ) ) AND attribute_id...

---