Read a random piece of data in MYSQL

SELECT * FROM res as T1 JOIN (select ROUND (RAND () * (= (select MAX (ID) from res)-(select min (id) from res)) + (select min ( ID)) as ID) as T2 WHERE t1.id >= t2.id ORDER by t1.id LIMIT 1;

SELECT * from ' res ' as T1 JOIN (select ROUND (RAND () * (= (select MAX (ID) from ' res ')-(select min (id) from ' res ')) + (select min (i d) from ' res ') as ID) as T2
WHERE t1.id>=t2.id ORDER by t1.id LIMIT 1;

Reference: http://blog.csdn.net/testcs_dn/article/details/10149293

Read a random piece of data in MYSQL