Answers for "php unique random number mysql"

php unique random number

$uniqueCode = md5(uniqid(rand(), true)); echo $uniqueCode;

how to generate a unique random number in mysql

#query 
SELECT FLOOR(RAND() * 99999)
AS random_num 
FROM YourTableName
WHERE "random_num" 
NOT IN (
  SELECT YourColumnName FROM YourTableName) LIMIT 1