26-07-2015, 07:10 AM
锘匡豢閹垮秳缍旀径杈Е閿涗浇顕Λ鈧弻顧筿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>
