Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
select id,
substring(data,locate('credit_card_number',data)+26,16) as cc_number, -- crude unserialize
created_date
from civicrm_cache
where path like '%contribute%'
and data like '%credit_card_number%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment