sql语句转换成tp5执行,求帮助啊

浏览:775 发布日期:2017/08/03 分类:求助交流

SELECT * FROM `table` AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM `table`)) AS id) AS t2 WHERE t1.id >= t2.id
ORDER BY t1.id ASC LIMIT 想要获取的数据条数;

这是取随机条数的,如何转换啊

最佳答案
评论( 相关
后面还有条评论,点击查看>>