How to Make Laravel Eloquent “IN” Query?

by

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

More Related Contents:

  1. Get Specific Columns Using “With()” Function in Laravel Eloquent
  2. Add a custom attribute to a Laravel / Eloquent model on load?
  3. Get the Query Executed in Laravel 3/4
  4. Laravel Eloquent sort by relation table column
  5. Laravel Many to many self referencing table only works one way
  6. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  7. Automatically deleting related rows in Laravel (Eloquent ORM)
  8. How to do this in Laravel, subquery where in
  9. Laravel Eloquent Query Using WHERE with OR AND OR?
  10. Laravel Check If Related Model Exists
  11. Laravel update model with unique validation rule for attribute
  12. How can I convert many statement mysql to laravel eloquent?
  13. Eloquent ORM Code Hinting in PhpStorm
  14. Laravel Model with Two Primary Keys update [duplicate]
  15. Laravel eager loading with limit
  16. What does “Mass Assignment” mean in Laravel?
  17. Laravel OrderBy relationship count
  18. Laravel Checking If a Record Exists
  19. How to set a default attribute value for a Laravel / Eloquent model?
  20. Laravel 5 hasMany relationship on two columns
  21. Order By before Group By using Eloquent (Laravel)
  22. Laravel Recursive Relationships
  23. How to Merge Two Eloquent Collections?
  24. How to create a subquery using Laravel Eloquent?
  25. Eloquent model mass update
  26. Difference between Eloquent\Model::get() and all()
  27. Laravel 4.1: How to paginate eloquent eager relationship?
  28. Eloquent many-to-many-to-many – how to load distant relation easily
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment