Skip to content
Readerstacks logo Readerstacks
  • Home
  • Softwares
  • Angular
  • Php
  • Laravel
  • Flutter
Readerstacks logo
Readerstacks
Laravel whereIn query with example

Mastering Laravel’s whereIn Query with Examples

Aman Jain, January 18, 2022October 21, 2023

Are you struggling with Laravel’s whereIn query? In this comprehensive guide, you’ll learn how to harness the power of Laravel’s whereIn Eloquent builder for creating dynamic queries, subqueries, and more. Explore the multiple ways to use this versatile method and gain a deep understanding with practical examples.

Below examples will work with any version of laravel 5 whereIn, laravel 6 whereIn, laravel 7 whereIn, laravel 8 whereIn, laravel 9 whereIn and laravel 10 whereIn.

To create where in in laravel eloquent we can use whereIn method which accepts two parameter one is column name and other one is list of Array.

Syntax to use:

whereIn('COLUMN_NAME', Array);

//OR

whereIn('COLUMN_NAME',Function);

The SQL equivalent of the above query will be

select * from `table` where  `COLUMN_NAME` in  ('Array')

//OR

select * from `table` where  `COLUMN_NAME` in  (select id from `table2')

As you can see i have written multiple way to use same method with different type of parameters. Now, let’s dive into some practical examples:

Example 1 – whereIn with array example

In this example, we’ll demonstrate a simple whereIn query with an array condition using two parameters

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $Article = Article::select("*")
                        ->whereIn("id", [1,2,3])
                        ->get();
      \\or
      DB::table('articles')->whereIn("id",[1,2,3])->get();

   }
}

Output will be :

select * from `articles` where `id` in (1,2,3) 

Example 2 – whereIn with subquery using closure function

In this example, we’ll use a closure function to create a subquery.

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $Article = Article::select("*")
                        ->where("category_id", function($query){
                            $query->select('article_type_id')
                             ->from(with(new ArticleCategory)->getTable())
                              ->whereIn('category_id', ['223', '15'])
                              ->where('active', 1);
                         })
                        ->get();
      \\or
       DB::table('articles')
       ->whereIn('id', function($query)
         {
          return $query->select('article_type_id')
              ->from('article_categories')
              ->whereIn('category_id', ['223', '15']);
      })->get();

      
   }
}

Output

select * from `articles` where `category_id` in (select article_type_id from article_categories where category_id in (223,15)  )

Example 3 – Multiple whereIn and orWhere condition

In this example, we’ll combine whereIn, orWhere, and subquery for more complex conditions

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
      $Article = Article::select("*")
                        ->whereIn("id",[1,2,3])
                        ->where(function($query){
                            $query->whereIn("cat_id",[2,4,6])->orWhere("status",1);
                        })
                        ->get();
   }
}

Output

select * from `articles` where `id` in (1,2,3) and (`cat_id` in (2,4,6) or `status` = 1)

Example 4 – Complicated Raw query in where

In this example we will use DB::raw to use complicated query in our laravel application. Sometimes we wanted to use aggregate function in laravel where so

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
use DB;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
      $Article = Article::select("*")
                        ->whereIn("id",\DB::raw("select id from table"))
                         ->get();

     //
    $Article = Article::select("*")
                        ->where(\DB::raw(" in (select id from table)"))
                         ->get(); 
   }
}

Output

select * from `articles` where `id` in (select id from table) 

Related

Php Laravel laravelphpwherewherein

Post navigation

Previous post
Next post

Related Posts

Php How to Use Broadcast to Send Web Socket Event in Laravel

How to Use Broadcast to Send Web Socket Event in Laravel ?

June 23, 2022June 26, 2022

Broadcasting is used to send real time message to client. In this article we will learn to use broadcast to send web socket event in laravel. Web sockets are used to communicate with client from server for real time communication. Broadcasting very useful to send update to client when any…

Read More
Php How to Upload image in Laravel

How to Upload image in Laravel 11 ?

July 7, 2024July 7, 2024

In this blog post, we’ll explore how to upload image using Laravel 11. Laravel 11 provides robust functionality for uploading and processing images, which is essential for various website tasks, from setting up profile pictures to handling document uploads. With Laravel 11, you can manage image uploads securely. Laravel utilizes…

Read More
Php Laravel blade for and loop varible

Laravel blade foreach, for and loop variable with example

December 18, 2021October 4, 2022

Laravel blade provides easy way to iterate a long list array or loop using @foreach and @for. @foreach and @for both used same structure as php foreach and for. In this article i will show you to use @foreach and @for loop with example and also the $loop variable. Loop…

Read More

Aman Jain
Aman Jain

With years of hands-on experience in the realm of web and mobile development, they have honed their skills in various technologies, including Laravel, PHP CodeIgniter, mobile app development, web app development, Flutter, React, JavaScript, Angular, Devops and so much more. Their proficiency extends to building robust REST APIs, AWS Code scaling, and optimization, ensuring that your applications run seamlessly on the cloud.

Categories

  • Angular
  • CSS
  • Dart
  • Devops
  • Flutter
  • HTML
  • Javascript
  • jQuery
  • Laravel
  • Laravel 10
  • Laravel 11
  • Laravel 9
  • Mysql
  • Php
  • Softwares
  • Ubuntu
  • Uncategorized

Archives

  • August 2025
  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • October 2024
  • July 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • July 2023
  • March 2023
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021

Recent Posts

  • Understanding High Vulnerabilities: A Closer Look at the Week of July 14, 2025
  • Exploring Fresh Resources for Web Designers and Developers
  • The Intersection of Security and Technology: Understanding Vulnerabilities
  • Mapping Together: The Vibrant Spirit of OpenStreetMap Japan
  • Understanding High Vulnerabilities: A Deep Dive into the Weekly Summary
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version