如何从mysql的两列中找到一个范围 - How to find a range from two columns in mysql

How to find a range from two columns in mysql

本文关键字：范围一个两列 mysql | 更新日期: 2023-09-27

我的值是45

我想检查这个值是否存在于数据库中。

问题是我有两列，比如:

--------------------
range_from  range_to
--------------------
   10 ------------ 20
--------------------
   21 ------------ 30
--------------------
   31 ------------ 40
--------------------
   41 ------------ 50
--------------------

如何找到这个值?

SELECT * FROM Score WHERE range_from='' AND range_to=''

通常你会使用关键字" BETWEEN "

SELECT * FROM score 
WHERE 45 BETWEEN range_from AND range_to

SELECT *
FROM score
WHERE range_from < 45 AND range_to > 45;

考虑到边界条件，我们可以考虑对上述答案进行小的修正

SELECT *
FROM score
WHERE range_from <= 50 AND range_to >= 50;