doufu2396 2015-03-18 06:20
浏览 78
已采纳

如何使Laravel雄辩“IN”查询?

I want to make query in Laravel Eloquent like here its raw MySQL query

SELECT  * from  exampleTbl where id in(1,2,3,4)

I have tried this in Laravel Eloquent but it's not working

DB::where("id IN(23,25)")->get()
  • 写回答

3条回答 默认 最新

  • douyan2470 2015-03-18 06:23
    关注

    Here is how you do in Eloquent

    $users = User::whereIn('id', array(1, 2, 3))->get();
    

    And if you are using Query builder then :

    $users = DB::table('users')->whereIn('id', array(1, 2, 3))->get();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?