MySQL随机取一条数据 取指定条数的数据

第一个：最简便 性能最差的：

SELECT * FROM tb_goods ORDER BY RAND() limit 3;

第二个：性能比较好但是只能出来一条的：

SELECT * 
FROM `goods` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(goods_id) FROM `goods`)-(SELECT MIN(goods_id) FROM `goods`))+(SELECT MIN(goods_id) FROM `goods`)) AS id) AS t2 
WHERE t1.goods_id >= t2.id
ORDER BY t1.goods_id LIMIT 1;

http://database.51cto.com/art/201010/229981.htm