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 this example, we will see carbon add minutes in laravel. Here we will give you a simple example of laravel carbo...
Dec-11-2020
In this article, we will see how to create a line chart in laravel 9 using highcharts. A line chart is a graph...
Oct-04-2022
In this article, we will see the laravel 10 apexcharts bar chart example. Here, we will learn about how to create a bar...
May-24-2023
In this tutorial, I will show you a session timeout example in laravel. After a set amount of idle time, the bootstrap w...
Jun-05-2020