SELECT * FROM tablename ORDER BY RAND() LIMIT 1
SELECT *
select *, rand() as random from ‘table‘ order by random limit 1
随机取数据,布布扣,bubuko.com
随机取数据
原文：http://www.cnblogs.com/mitang/p/3602334.html
