An Interest In:
Web News this Week
- April 22, 2024
- April 21, 2024
- April 20, 2024
- April 19, 2024
- April 18, 2024
- April 17, 2024
- April 16, 2024
April 11, 2022 03:19 am GMT
Original Link: https://dev.to/techsolutionstuff/laravel-wherein-and-wherenotin-query-example-3nnc
Laravel whereIn and whereNotIn Query Example
In this tutorial, 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 make a laravel wherein subquery and laravel where not in the subquery.
So, here we will see the laravel whereIn and laravel whereNotIn query with example. Also, you use whereIn and WhereNotIn in laravel 6, Laravel 7 and Laravel 8.
Syntax :
whereIn(Coulumn_name, Array)
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); }
You might also like :
Original Link: https://dev.to/techsolutionstuff/laravel-wherein-and-wherenotin-query-example-3nnc
Share this article:
Tweet
View Full Article
Dev To
An online community for sharing and discovering great ideas, having debates, and making friendsMore About this Source Visit Dev To