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 show you laravel whereMonth and whereYear examples. whereMonth and whereYear are...
Jan-25-2021
In this article, we will see laravel 9 insert multiple records in the database. Here, we will learn how to ins...
Dec-16-2022
Hello developers! 👋 Ever found yourself dealing with a DataTable in Laravel and wished for a nifty way to filter th...
Feb-07-2024
Angular 15 is the latest iteration of one of the most popular JavaScript frameworks for building dynamic web application...
Jun-05-2023