MySQLでテーブルの値と重複しない乱数を生成する

SELECT FLOOR(RAND() * 9999) AS random_num
FROM table 
WHERE "random_num" NOT IN (SELECT table.uniqueid FROM table)
LIMIT 1