我在SQLite数据库中有subjects表和tutorials表。我想选择当前教程。以下是我的表格:
Subjects table:
------------------- | id | name | ------------------- | 1 | Chemistry | | 2 | Physic | -------------------
Tutorials table:
----------------------------------------- | id | name | subj_id | completed | ----------------------------------------- | 1 | chapter 1 | 1 | 1 | | 2 | chapter 2 | 1 | 0 | | 3 | chapter 3 | 1 | 0 | | 4 | chapter 1 | 2 | 1 | | 5 | chapter 2 | 2 | 1 | | 6 | chapter 3 | 2 | 0 | | 7 | chapter 4 | 2 | 0 | -----------------------------------------
我的当前 eloquent 是:
$query->where('completed', false)->groupBy('subj_id')->get();
它返回以下内容:
-----------------------------------------
| id | name | subj_id | completed |
-----------------------------------------
| 3 | chapter 3 | 1 | 0 |
| 7 | chapter 4 | 2 | 0 |
-----------------------------------------
现在我希望选择id为2和6。
-----------------------------------------
| id | name | subj_id | completed |
-----------------------------------------
| 2 | chapter 2 | 1 | 0 |
| 6 | chapter 3 | 2 | 0 |
-----------------------------------------
如何使用sqlite获取id为2和6的数据?