随机取mysql的数据

看了博客http://dditblog.com/itshare_192.html

记录下：

SELECT * FROM xc_optional_group_items AS r1 JOIN

(SELECT ROUND(RAND() * (SELECT MAX(id) FROM xc_optional_group_items)) AS id) AS r2

WHERE r1.id >= r2.id

ORDER BY r1.id ASC

LIMIT 2;