MYSQL随机查询使用方法：

       随机获得5条数据(Id不连续)

select *, rand() as random from `table` order by random limit 5

SELECT * FROM `table` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `table` ) ORDER BY id LIMIT 5;

SELECT * FROM `table` WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `table`))) ORDER BY id LIMIT 5;

SELECT * FROM `table` WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`)) + (SELECT MIN(id) FROM `table`))) ORDER BY id LIMIT 5;

       随机获得5条数据（Id连续）

SELECT * FROM `table` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`))+(SELECT MIN(id) FROM `table`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 5;

       关于ID连续与不连续的意思

       ID连续：即查询出来的数据id是连续的，如：1，2，3，4，5、15，16，17，18，19

       Id不连续：即查询出来的数据id是不连续的，如：1，8，9，14，19、12，18，20，28，35

标签  技巧网站开发

按键盘左右方向键可快速浏览上一篇(←)、下一篇(→)