Loop to check duplicate random numbers in MYSQL

how to create a query in MYSQL, to compare a random number with the previous random numbers and if it exists it should generate another random number