Laravel 9 whereIn / whereNotIn / orWhereIn / orWhereNotIn

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)

Read Also: Laravel 9 whereBetween Query Example

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

Read Also: Laravel 9 Where Condition Example

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:

• Read Also: How To Send Email Using Markdown Mailable Laravel 9
• Read Also: Laravel 9 Foreach Loop Variable Example
• Read Also: Laravel 9 Inner Join Query Example
• Read Also: Laravel 9 AJAX CRUD Example

If this post was helpful, please click the clap 👏 button below.