SELECT * FROM 'table' AS t1 JOIN ( SELECT ROUND( # 最小值 + (1 至 最小与最大值差) RAND() * ( (SELECT MAX(id) FROM 'table')-(SELECT MIN(id) FROM 'table') ) +(SELECT MIN(id) FROM 'table') ) AS id ) AS t2 WHERE t1.id &gt。= t2.id ORDER BY t1.id LIMIT 1。&nbsp。最后在php中对这两个语句进行分别查询10次，前者花费时间 0.147433 秒，后者花费时间 0.015130 秒。看来采用JOIN的语法比直接在WHERE中使用函数效率还要高很多。&nbsp。