How to Make Laravel Eloquent "IN" Query?

php laravel orm eloquent
Ravi Jethva picture Ravi Jethva · Mar 18, 2015 · Viewed 164.1k times · Source

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()

Answer

Raheel picture Raheel · Mar 18, 2015

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();

Related questions

Get Specific Columns Using “With()” Function in Laravel Eloquent

I have two tables, User and Post. One User can have many posts and one post belongs to only one user. In my User model I have a hasMany relation... public function post(){ return $this->hasmany('post'); } And in …

Read More
Add a custom attribute to a Laravel / Eloquent model on load?

I'd like to be able to add a custom attribute/property to an Laravel/Eloquent model when it is loaded, similar to how that might be achieved with RedBean's $model->open() method. For instance, at the moment, in my …

Read More
Get the Query Executed in Laravel 3/4

How can I retrieve the raw executed SQL query in Laravel 3/4 using Laravel Query Builder or Eloquent ORM? For example, something like this: DB::table('users')->where_status(1)->get(); Or: (posts (id, user_id, ...)) User::find(1)…

Read More