正文

mysql随机查询

IP云
IP云V管理员/0 阅读
08/14
小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

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 t2where t1.id >= t2.idorder by t1.id limit 1;

;