dimanche 7 octobre 2018

Request to replace all the vowels in a mysql column with a random vowel

I have a mysql database with the table Clients and would like to hide my sensitive data (to give the database to a developper) by replacing all the vowels of the FirstName and LastName columns by random vowels. So all the "A", "E", "I", "O", "U" found in the string should be replaced by a random letter in the group "A", "E", "I", "O", "U". Identically all the "a", "e", "i", "o", "u" should be replaced by a random letter in the group "a", "e", "i", "o", "u".

Thanks for you answer.




Aucun commentaire:

Enregistrer un commentaire