随机从一张表取出若干行

SELECT * FROM table AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM table)-(SELECT MIN(id) FROM table))+(SELECT MIN(id) FROM table)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY RAND() asc LIMIT 200;

SELECT * FROM table ORDER BY RAND() LIMIT 200;