Magento: Erase saved credit card data
Posted by Ivan Prorskuryakov under Magento snippets
-- 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 != ""
);
...