要随机选择,请使用ORDER BY RAND()。要仅选择2个值,请在MySQL中使用LIMIT 2。让我们首先创建一个表-mysql> create table DemoTable1815
(
Question text
);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable1815 values('What is your name?');
mysql> insert into DemoTable1815 values('What is your college name?');
mysql> insert into DemoTable1815 values('What is your nick name?');
mysql> insert into DemoTable1815 values('What is your enemy name?');
使用select语句显示表中的所有记录-mysql> select * from DemoTable1815;
这将产生以下输出-+----------------------------+
| Question |
+----------------------------+
| What is your name? |
| What is your college name? |
| What is your nick name? |
| What is your enemy name? |
+----------------------------+
4 rows in set (0.00 sec)
这是只随机选择2条记录的查询-mysql> select * from DemoTable1815 order by rand() limit 2;
这将产生以下输出-+----------------------------+
| Question |
+----------------------------+
| What is your college name? |
| What is your enemy name? |
+----------------------------+
2 rows in set (0.00 sec)