在MySQL的两个列值之间选择一个特定值?
让我们首先创建一个表-
mysql> create table DemoTable787 ( Score1 int, Score2 int, Name varchar(100) );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable787 values(34,56,'Chris'); mysql> insert into DemoTable787 values(73,86,'Robert'); mysql> insert into DemoTable787 values(90,99,'David'); mysql> insert into DemoTable787 values(80,89,'Adam');
使用select语句显示表中的所有记录-
mysql> select *from DemoTable787;
这将产生以下输出-
+--------+--------+--------+ | Score1 | Score2 | Name | +--------+--------+--------+ | 34 | 56 | Chris | | 73 | 86 | Robert | | 90 | 99 | David | | 80 | 89 | Adam | +--------+--------+--------+ 4 rows in set (0.00 sec)
以下是在两列的值之间选择特定值的查询-
mysql> select Name from DemoTable787 where 56 between Score1 and Score2;
这将产生以下输出-
+-------+ | Name | +-------+ | Chris | +-------+ 1 row in set (0.00 sec)