title: MySQL - Searching for CC numbers
body: <p>I inherited a MySQL server that has CC numbers stored in plaintext. due to PCI requirements, I need to find the numbers and mask them. The trick is they are stored in a field with other text as well. I need to find a way to search for cc numbers and change just those, not the rest of the text.</p>
  <p>I have tried the masking feature in MySQL, but it doesn't work for this version. I also looked up a few different sites but can't seem to find anything that will really help with my particular instance.</p>
  <p><strong>Edit</strong>
  to explain better. the previous admin didn't tell the operators to not take CC info through the live chat system. The system is using SSL but the chat history is stored in plain text in a MySQL DB. The company isn't PCI compliant (as far as getting scanned and SAQ is concerned) so we cannot have CC numbers stored anywhere. but the numbers are given in the middle of a conversation. If they were in their own column then that wouldn't be a big deal.</p>
  <p><strong>EDIT</strong>
  I have tried using regexp to just try and search for CC #'s but now I am getting an operand error, which is lazy quantifiers I believe.</p>
  <pre><code>SELECT * FROM table_name Where text regexp '^4[0-9]{12}(?:[0-9]{3})?$'
  </code></pre>
  <p>Any Ideas?</p>