neilbradley/pans.sql

Created December 19, 2017 09:53

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/neilbradley/fed981de2bfb259bc775c392ecfa2879.js"></script>
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

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