从数据库访问随机行而无需重复 [英] Accessing random rows from database without repetition

问题描述

我设计了一个使用MySQL数据库作为后端的测验方案.

I have designed a quiz scenario using MySQL database as my backend.

我总共有20个问题，我希望从数据库中以随机顺序显示它们. 我已经尝试过:

I have a total of 20 questions and I would want to display them in random order from the database. I have tried :

SELECT * from mst_que ORDER BY RAND();

以上查询的作用是重复几行.

What the above query does is repeat few rows.

推荐答案

如果表包含重复的记录，请使用SELECT DISTINCT过滤掉它们.

If the table contains duplicate records, use SELECT DISTINCT to filter them out.

SELECT DISTINCT *
FROM mst_que
ORDER BY RAND()

这篇关于从数据库访问随机行而无需重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！