10-04-2017, 09:19 PM
l ?br /><font color="red">SELECT filename
FROM xr_links AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM xr_links )-(SELECT MIN(id) FROM xr_links ))+(SELECT MIN(id) FROM xr_links )) AS id) AS t2
WHERE t1.id >= t2.id and status=1
ORDER BY t1.id LIMIT 1</font> l ?br /><font color="red">update xr_links set status=1</font>