php - 如何在两个字段mysql上使用max和min进行搜索？

Question

我有这张表(MySQL):

|id|min|max|info|
+--+---+---+----+
|1 |18 |24 | ...|
+--+---+---+----+
|2 |22 |26 | ...|

SQL:

SELECT * FROM myTable WHERE max <= 21 AND min >= 21

结果:

NULL

解决方法:

SELECT * FROM myTable WHERE 21 <= max AND 21 >= min

Answer 1

max <= 21 没有行.在两行 max大于21!