In this article, we will see Laravel 9 whereIn / whereNotIn / orWhereIn / orWhereNotIn Query Example. The whereIn() method is used to check the value in a given range of the value. So, we will learn laravel 9 whereIn query, laravel 9 whereNotIn query, laravel 9 orWhereIn query, laravel 9 orWhereNotIn query example.
The whereIn
method verifies that a given column's value is contained within the given array. The whereNotIn
method verifies that the given column's value is not contained in the given array.
Syntax of SQL:
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);
In this example, we will retrieve all records of employees with IN conditions.
SELECT * FROM employee WHERE emp_id IN (1,2,3)
Syntax of Laravel:
whereIn(Coulumn Name, Array of Value)
In this example, we will retrieve data using the whereIn() method.
$employee = DB::table('employee')
->whereIn('id', [1, 2, 3])
->get();
In this example, we will retrieve data using the whereNotIn() method.
$employee = DB::table('employee')
->whereNotIn('id', [1, 2, 3])
->get();
In this example, we will retrieve data using the orWhereIn() method.
$employee = DB::table('employee')
->where('role','=','software engineer')
->orWhereIn('emp_id', [1, 2, 3])
->get();
In this example, we will retrieve data using the orWhereNotIn() method.
$employee = DB::table('employee')
->where('role','=','software engineer')
->orWhereNotIn('emp_id', [1, 2, 3])
->get();
You might also like:
In this article, we will see laravel 9 phone number validation using regex. In laravel 9 we will see different meth...
Oct-25-2022
In this article, we will see how to create a pie chart in laravel 9 using highcharts. A pie chart is a circular statisti...
Oct-05-2022
In this article, we will see the bootstrap modal in angular 13. Ng Bootstrap is developed from bootstrap and they p...
Jun-10-2022
In this tutorial we will see how to generate pdf and send email in laravel 8. For generating PDF file we will use l...
Dec-20-2021