mysql - 选择指定行到具有特定条件的某行之间的行

Question

你好
假设我们有一个表(有 2 个字段，分别是 version、compatible)，数据如下:

+-------+------+  
| 0.1.1 | true |  
+-------+------+  
| 0.1.2 | false|  
+-------+------+  
| 0.1.3 | true |  
+-------+------+  
| 0.1.4 | true |  
+-------+------+  
| 0.1.5 | true |  
+-------+------+  
| 0.1.6 | false|  
+-------+------+  
| 0.1.7 | true |  

现在我想选择所有行 version = '0.1.3'从前一行compatible = false到下一行 compatible = false
结果应该是 0.1.2 , 0.1.3 , 0.1.4 , 0.1.5
我该怎么做？

Answer 1

SELECT version, compatible
    FROM YourTable
    WHERE version >= '0.1.3'
        AND version < (SELECT version
                           FROM YourTable
                           WHERE version > '0.1.3'
                               AND compatible = 'false'
                           ORDER BY version
                           LIMIT 1)
    ORDER BY version