mysql查询随机1条，5条

最新推荐文章于 2023-03-15 15:11:42 发布

xiaoqforever

最新推荐文章于 2023-03-15 15:11:42 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： DB 文章标签： mysql 随机5条随机一条

本文链接：https://blog.youkuaiyun.com/xiaoqforever/article/details/16115721

DB 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了几种使用SQL进行随机数据抽取的方法，包括不同数量的数据抽取及是否使用JOIN操作。通过对具体SQL语句的解析，读者可以了解如何高效地从数据库中随机选取记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//随机1条
SELECT * FROM
zhuizhu_weixin AS t1 JOIN
(SELECT ROUND(RAND() * ((SELECT MAX(id) FROM zhuizhu_weixin)-(SELECT MIN(id) FROM zhuizhu_weixin))+(SELECT MIN(id) FROM zhuizhu_weixin)) AS id) AS t2
WHERE t1.id >= t2.id
ORDER BY t1.id LIMIT 1;

//随机5条不用join
SELECT *
FROM zhuizhu_user
WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM zhuizhu_user )
ORDER BY id LIMIT 5;

//随机1条不用join
SELECT * FROM zhuizhu_weixin
WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM zhuizhu_weixin -(SELECT MIN(id) FROM zhuizhu_weixin + (SELECT MIN(id) FROM zhuizhu_weixin)))
ORDER BY id LIMIT 1;

//随机5条用join 连续
SELECT *
FROM zhuizhu_user AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM zhuizhu_user)) AS id) AS t2
WHERE t1.id >= t2.id
ORDER BY t1.id ASC LIMIT 5;

//随机1条
SELECT * FROM zhuizhu_weixin
WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM zhuizhu_weixin)-(SELECT MIN(id) FROM zhuizhu_weixin)) + (SELECT MIN(id) FROM zhuizhu_weixin)))
ORDER BY id LIMIT 1