In this article, we will see the laravel whereIn and whereNotIn query examples. laravel query builder provides many different types of queries to filter data from databases. The whereIn method verifies that a given column's value is contained within the given array and the whereNotIn method verifies that the given column's value is not contained in the given array.
Also, you can check if the value exists or not using the whereIn function in laravel 6, laravel 7, and laravel 8. You may create whereIn and whereNotIn subquery in laravel 7/8.
So, let's see laravel 7/8 wherein the query and SQL in the query example.
Syntax:
Example:
SQL Query
SELECT * FROM students WHERE roll_no IN (1,2,3)
Laravel whereIn Query
public function index()
{
$students = Student::select("*")
->whereIn('roll_no', [1,2,3])
->get();
dd($students);
}
Laravel whereNotIn Query
public function index()
{
$roll_no = '1,2,3';
$array1 = explode(',', $roll_no);
$student = Student::select("*")
->whereNotIn('roll_no', $array1)
->get();
dd($student);
}
In tutorial we will see how to validate laravel 8 image upload validation. In laravel 7/8 you can validate image using t...
Dec-15-2021
In this article, we will see target class does not exist in laravel 8 and how to fix target class not found in...
Sep-23-2020
In this article, we will see laravel 9 many to many polymorphic relationship. many to many polymorphic relationship more...
Apr-06-2022
In this article, we will see how file uploads in react js. File uploading means a user from a client machine wants...
Sep-05-2022