how to mask information in mysql

Database: mysql

Let's assume that a database dump is made "production for the bank" development "where developers will work and I do not want developers to see sensitive information like social security number, credit card, etc ... how could I to mask this data in mysql?

I need to masquerade the information in a random way but if they know how to mask using XXX, it would be a great help

Example:

Original Credit card 5277 8532 3986 2995

Masked with X Credit card 5277 XXXX XXXX XXXX

Masked randomly Credit card 5216 2345 5433 5731