Anonymizing and masking sensitive data in SQL

random.sql

-- Random Int
SELECT FLOOR(RAND() * 100);

-- Random float
select FLOOR(RAND() * 1000 ) + round(rand() * 0.49 + 0.01, 2);

-- Random Srting
SELECT MD5(RAND());
SELECT TO_BASE64(UNHEX(HEX(MD5(RAND()))));

-- Random Srting with random length
SELECT SUBSTR(MD5(RAND()), 1, FLOOR(RAND() * 12) + 1);
SELECT SUBSTRING(TO_BASE64(UNHEX(HEX(MD5(RAND())))) FROM 1 FOR FLOOR(RAND() * 10) + 1);

-- Random char
SELECT substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', rand()*26+1, 1);

-- get domain from email
SELECT SUBSTRING_INDEX(email,  '@', -1);

-- random email
SELECT CONCAT(SUBSTR(MD5(RAND()), 1, FLOOR(RAND() * 12) + 1), '@', SUBSTRING_INDEX(email,  '@', -1));