SELECT id
FROM dede_archives t1
JOIN (
SELECT ROUND( RAND( ) * (
SELECT MAX( id )
FROM dede_archives ) ) AS nid
FROM dede_archives
LIMIT 1
)t2 ON t1.id = t2.nid
mysql 随机查出优化
最新推荐文章于 2021-12-29 02:28:01 发布
SELECT id
FROM dede_archives t1
JOIN (
SELECT ROUND( RAND( ) * (
SELECT MAX( id )
FROM dede_archives ) ) AS nid
FROM dede_archives
LIMIT 1
)t2 ON t1.id = t2.nid