Laravel的ORM支持IN
查询吗?
也就是说,在普通的旧SQL中,我可以编写
select * from students where id IN (3503, 3504);
并且查询返回两行。Laravel的ORM支持这种参数化查询语法吗?我试过
$students = Student::whereRaw('id IN (?)',['3503, 3504'])->get();
$students = Student::where('id','in','3503,3504')->get();
$students = Student::where('id','in',['3503,3504'])->get();
但似乎什么都不起作用。Laravel 4.2,如果重要的话。
当然可以:
$students = Student::whereIn('id',['3503','3504'])->get();