MySql教程

mysql随机返回一条数据

本文主要是介绍mysql随机返回一条数据,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
select * from biz_question ORDER BY RAND(id) LIMIT 1;
SELECT * FROM biz_question  AS t1  
JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM biz_question)-(SELECT MIN(id) FROM biz_question))+(SELECT MIN(id) FROM biz_question)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 1

建议第二种,效率高一些

这篇关于mysql随机返回一条数据的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!