头像

RAND随机查询

来源:https://www.sucaihuo.com/topic/55.html 素材火管理员 2014-09-18 20:48浏览(177)


SELECT * FROM `sucai_js` ORDER BY RAND() LIMIT 1


优化后:

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

标签: phpMysql
评论0
头像

系统已开启自动识别垃圾评论机制,识别到的自动封号,下载出错或者资源有问题请联系全栈客服QQ 1915635791

1 2