SELECT a.* FROM zh_sys_share a JOIN (SELECT ROUND(RAND()*
((SELECT MAX(id) FROM zh_sys_share)-(SELECT MIN(id) FROM zh_sys_share))+(SELECT MIN(id) FROM zh_sys_share)) AS id) AS b on a.id >= b.id where type =1
and isok='1' LIMIT 1
mysql随机一条数据
最新推荐文章于 2024-06-19 19:08:59 发布