SELECT * FROM faq WHERE id >= ((SELECT MAX(id) FROM faq)-(SELECT MIN(id) FROM faq)) * RAND() + (SELECT MIN(id) FROM faq) LIMIT 9
随机从数据表中取N条数据(mysql)
最新推荐文章于 2024-08-14 23:11:00 发布
SELECT * FROM faq WHERE id >= ((SELECT MAX(id) FROM faq)-(SELECT MIN(id) FROM faq)) * RAND() + (SELECT MIN(id) FROM faq) LIMIT 9