zhaojishun 的博客

mysql 高效率随机查询
百万数据级

SELECT phtoturl FROM photo WHERE id >= ((SELECT MAX(id) FROM photo)-(SELECT MIN(id) FROM photo)) * RAND() + (SELECT MIN(id) FROM photo) limit 10;