SELECT * FROM tbl_school WHERE id = (
SELECT random_num
FROM (
SELECT FLOOR(RAND() * 999999) AS random_num
FROM tbl_school
UNION
SELECT FLOOR(RAND() * 999999) AS random_num
) AS ss
WHERE "random_num" NOT IN (SELECT id FROM tbl_school)
LIMIT 1
)
SELECT FLOOR(RAND() * 999999) AS random_num
select left(uuid(),8);
SELECT UUID()