Skip to content

Instantly share code, notes, and snippets.

@neilbradley

neilbradley/pans.sql

Created December 19, 2017 09:53
Show Gist options
  • Save neilbradley/fed981de2bfb259bc775c392ecfa2879 to your computer and use it in GitHub Desktop.
Save neilbradley/fed981de2bfb259bc775c392ecfa2879 to your computer and use it in GitHub Desktop.
Download ZIP
Search SagePay Suite Transaction Table in Magento for Customers who mistakenly entered a Credit Card PAN into the Nickname field
Raw
pans.sql
SELECT * FROM sagepaysuite_transaction WHERE sagepaysuite_transaction.nickname REGEXP '[[:<:]]([[:digit:]][- ]?){13,16}[[:>:]]'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment