MySQL随机获取数据

随机获取10条数据

SELECT * FROM `tp_navtype` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `tp_carousel` ) ORDER BY id LIMIT 3;

随机获取1条数据

SELECT * FROM `tp_navtype` ORDER BY RAND() limit 1