title: Mysql query to search for credit card numbers
body: <p>I am not a developer or a MySQL DBA (far from it!) but regularly deal with MySQL databases at the moment. I've searched high and low but can't get my head around writing a regular expression query for this so reaching out to the experts.</p>
  
  <p>I would like to know if anyone can give me a hint on how to write a MySQL query which would return results for a credit card number in a field...</p>
  
  <ul>
  <li>A card number in the format XXXX-XXXX-XXXX-XXXX</li>
  <li>A card number with just the 16 digits with no dashes</li>
  </ul>
  
  <p>The goal is to search our MySQL databases for cardholder data so we can basically get rid...!</p>
  
  <p>Many thanks in advance
  Sarah</p>