How to Make Laravel Eloquent IN Query

Question

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   - gt get

User · Answer

If you are using Query builder then you may use a blow

DB::table(Newsletter Subscription)
->select('*')
->whereIn('id', $send_users_list)
->get()

If you are working with Eloquent then you can use as below

$sendUsersList = Newsletter Subscription:: select ('*')
                ->whereIn('id', $send_users_list)
                ->get();

User · Answer

As  Raheel Answered it will fine but if you are working with Laravel 7 6 Then Eloquent whereIn Query  Example1   users   User  wherein  id   1 2 3  - gt get     Example2   users   DB  table  users  - gt whereIn  id    1  2  3  - gt get     Example3   ids    1 2 3     users   User  wherein  id   ids - gt get

User · Answer

Syntax    data   Model  whereIn  field name    1  2  3  - gt get      Use for Users Model   usersList   Users  whereIn  id    1  2  3  - gt get

User · Answer

Here is how you do in Eloquent   users   User  whereIn  id   array 1  2  3  - gt get      And if you are using Query builder then     users   DB  table  users  - gt whereIn  id   array 1  2  3  - gt get

[php] How to Make Laravel Eloquent "IN" Query?

Examples related to php

Examples related to laravel

Examples related to orm

Examples related to eloquent