use whereIn Query in Laravel?

In this article, i will share with you very simple but most used laravel query example how to use whereIn query in laravel eloquent. I will give you a very simple example of how to use whereIn in laravel.

If you want to match one record id given by id’s array then you should be used whereIn for done these tasks.

Syntax

whereIn(Coulumn_name, Array);

Simple SQL Query

SELECT *
  	FROM articles
  	WHERE id IN (2,3,1)

Now, we will see how to use in laravel application in many ways

Example – 1

In this example, we will simply get some articles from the given by categories array.

public function index()
{
    $articles = Article::select("*")
        ->whereIn('category_id', [4, 5, 6])
        ->get();
  
    dd($articles);                    
}

Example -2

In this example, i will show you how to match comma-separated string values in whereIn().

public function index()
{
	$categoryIdString = '2,3,4';
    $categoryIds = explode(',', $categoryIdString);

    $articles = Article::select("*")
        ->whereIn('category_id', $categoryIds)
        ->get();
  
    dd($articles);                    
}

Example -3

You can also use a string array with whereIn().

public function index()
{
    $articles = Article::select("*")
        ->whereIn('tag_name', ['laravel', 'python', 'react', 'anguler', 'node'])
        ->get();
  
    dd($articles);                    
}

i hope it will be help a lot.