MySQL读取随机记录的实现方法有很多,现总结两种: 用法一:适用于小数据量的数据表(Table)
SELECT * from TABLE order by RAND() LIMIT 1
用法二:可用于大数据量的数据表(Table)
SELECT Column FROM table AS r1 JOIN (SELECT MAX(Id) AS wid_c FROM table) AS tmp1 WHERE r1.Id >= (SELECT (RAND() * tmp1.wid_c) AS id) LIMIT 10