Laravel 9 whereIn / whereNotIn / orWhereIn / orWhereNotIn

WebSolutionStuff | Oct-17-2022 | Categories : Laravel

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, ...);

 

Example 1:

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)

 

 

Example 2:

In this example, we will retrieve data using the whereIn() method.

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

 

Example 3:

In this example, we will retrieve data using the whereNotIn() method.

$employee = DB::table('employee')
                    ->whereNotIn('id', [1, 2, 3])
                    ->get();

 

Example 4:

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();

 

 

Example 5:

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:



Recommended Post


Featured Post







Follow us
facebooklogo github instagram twitter

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock or some other adblocking software which is preventing the page from fully loading.

We need money to operate the site, and almost all of it comes from our online advertising.

Please add websolutionstuff to your ad blocking whitelist or disable your adblocking software.

×