MySQL 从头开始​​选择直到 row = string

Question

有这张表:

+----+-------+---------+-----+
| id | group | name    | age |
+----+-------+---------+-----+
| 1  | a     | John    | 11  |
+----+-------+---------+-----+
| 2  | a     | Rachel  | 12  |
+----+-------+---------+-----+
| 3  | a     | Sarah   | 11  |
+----+-------+---------+-----+
| 4  | a     | Joe     | 14  |
+----+-------+---------+-----+
| 5  | b     | Richard | 13  |
+----+-------+---------+-----+
| 6  | b     | Zoe     | 12  |
+----+-------+---------+-----+

我想编写一个查询，以便获取从表的开头 ( id = 1 ) 到 group = 'b' 的所有值, 所以我得到一个这样的表:

+----+-------+--------+-----+
| id | group | name   | age |
+----+-------+--------+-----+
| 1  | a     | John   | 11  |
+----+-------+--------+-----+
| 2  | a     | Rachel | 12  |
+----+-------+--------+-----+
| 3  | a     | Sarah  | 11  |
+----+-------+--------+-----+
| 4  | a     | Joe    | 14  |
+----+-------+--------+-----+

谁能帮帮我？非常感谢!

Answer 1

你会做这样的查询:

select tt.*
from thistable tt
where tt.id < (select min(tt2.id) from thistable tt2 where tt2.`group` = 'b');

请注意，group 是列名的糟糕名称，因为它是保留字。