mysql随机获取数据

效率比较高的,推荐,但是随机的有序的=-=

SELECT * FROM address WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM address))) ORDER BY id LIMIT 0,10

参考:
blog.csdn.net/qdujunjie/a…