select CHAR(FLOOR(RAND()*10)+48); # obtiene un numero aleatorio del 0 al 9
select CHAR(FLOOR(RAND()*26)+65); # obtiene una letras mayusculas aleatoria A a LA Z
select CHAR(FLOOR(RAND()*26)+97); # obtiene una letras mayusculas aleatoria a a LA z
#NUMEROS Y LETRAS ALEATORIAS
SELECT CONCAT(
(SELECT CASE WHEN a.aa='0' THEN 'a'
WHEN a.aa='1' THEN 'b'
WHEN a.aa='l' THEN 'g'
WHEN a.aa='o' THEN 'q'
ELSE a.aa
END AS d
FROM (SELECT LCASE(CONV(FLOOR(RAND()*36),10,36)) AS aa) AS a),
(SELECT CASE WHEN a.aa='0' THEN 'a'
WHEN a.aa='1' THEN 'b'
WHEN a.aa='l' THEN 'g'
WHEN a.aa='o' THEN 'q'
ELSE a.aa
END AS d
FROM (SELECT LCASE(CONV(FLOOR(RAND()*36),10,36)) AS aa) AS a),
(SELECT CASE WHEN a.aa='0' THEN 'a'
WHEN a.aa='1' THEN 'b'
WHEN a.aa='l' THEN 'g'
WHEN a.aa='o' THEN 'q'
ELSE a.aa
END AS d
FROM (SELECT LCASE(CONV(FLOOR(RAND()*36),10,36)) AS aa) AS a),
(SELECT CASE WHEN a.aa='0' THEN 'a'
WHEN a.aa='1' THEN 'b'
WHEN a.aa='l' THEN 'g'
WHEN a.aa='o' THEN 'q'
ELSE a.aa
END AS d
FROM (SELECT LCASE(CONV(FLOOR(RAND()*36),10,36)) AS aa) AS a),
(SELECT CASE WHEN a.aa='0' THEN 'a'
WHEN a.aa='1' THEN 'b'
WHEN a.aa='l' THEN 'g'
WHEN a.aa='o' THEN 'q' ELSE a.aa
END AS d
FROM (SELECT LCASE(CONV(FLOOR(RAND()*36),10,36)) AS aa) AS a),
(SELECT CASE WHEN a.aa='0' THEN 'a'
WHEN a.aa='1' THEN 'b'
WHEN a.aa='l' THEN 'g'
WHEN a.aa='o' THEN 'q' ELSE a.aa
END AS d
FROM (SELECT LCASE(CONV(FLOOR(RAND()*36),10,36)) AS aa) AS a),
(SELECT CASE WHEN a.aa='0' THEN 'a'
WHEN a.aa='1' THEN 'b'
WHEN a.aa='l' THEN 'g'
WHEN a.aa='o' THEN 'q'
ELSE a.aa
END AS d
FROM (SELECT LCASE(CONV(FLOOR(RAND()*36),10,36)) AS aa) AS a)
)AS NAME;
