Home / Snippets / Laravel Where In Condition

Laravel Where In Condition

204

3 years ago

0 comments

You can write a whereIn condition to explicitly get an exact result in Laravel by passing in an array at the 2nd parameter of the method. The whereIn method verifies that a given column's value is contained within the given array and you can write the query like below.

<?php

Post::query()
    ->whereIn('id', [1, 2, 3])
    ->get();

DB::table('posts')->whereIn('id', [1, 2, 3])
    ->get();

// result: posts with an id of 1, 2, 3 only