Random ids between limit IDs using RAND() php msql

Question

hi anyone know about how to use Random wallpaperid between limit IDs using RAND() php msql

i use this but its RAND() whole database

$sql_wallpaper = "SELECT * FROM wallpaper WHERE RAND()>0.9 ORDER BY RAND() LIMIT 0,5";
$res_wallpaper = mysql_query($sql_wallpaper);

reply please

Answer 1

Do you mean this?

$sql_wallpaper = "SELECT * FROM wallpaper WHERE id>Min AND id<Max ORDER BY RAND() LIMIT 1";
$res_wallpaper = mysql_query($sql_wallpaper);

Answer 2

Your question indicates you're using PHP.

Why not just use this?

$rand_id = rand(1, 100);

and then

SELECT * FROM wallpaper WHERE id = $rand_id LIMIT 1