随机的获取mysql中的一条语句快速sql语句 （转载）

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 t2   WHERE t1.id >= t2.id   ORDER BY t1.id LIMIT 1;
需要注意在ORDER BY从句里面不能使用RAND()函数，因为这样会导致数据列被多次扫描