使用了mysql的随机函数RAND(),比如随机取12条:
SELECT * FROM video_info ORDER BY RAND() LIMIT 12
但是效率较差,执行时间大概用了8秒上下,优化一下并加上条件后:
SELECT * FROM video_info WHERE v_id >= (SELECT floor(RAND() * (SELECT MAX(v_id) FROM video_info))) ORDER BY play_num desc LIMIT 12;
其中v_id >= (SELECT floor(RAND() * (SELECT MAX(v_id) FROM video_info)))做了随机功能,更详细的资料见原作者:
http://www.jb51.net/article/42229.htm