mysql 随机获取100记录

1：select * from t_sms_number_section ORDER BY RAND() limit 100;-- 7.140ms

 

:2：SELECT * FROM t_sms_number_section AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM       t_sms_number_section)) AS id) AS r2 WHERE r1.id <= r2.id ORDER BY RAND(r1.id) ASC LIMIT 100;