Where not in Laravel
2024-04-27 14:57:14
Deepika
Laravel
How to use where not in clause in Laravel?
WhereNotIn method of laravel db builder and Eloquent is used to select records that are not in given array.
Where not in Example
whereNotIn Query Builder Example:
DB::table('yourtable')->select(..)->whereNotIn('id', [100,200])->get();
whereNotIn Eloquent Example:
YourModel::select(..)->whereNotIn('id', [100,200])->get();
This post is submitted by one of our members. You may submit a new post here.
- How to get all records in Laravel?
- Adding Multiple Order By clause in Laravel
- Disabling timestamps in Laravel Eloquent
- IN query in Laravel Eloquent
- Getting Random rows in Laravel Eloquent.
- Using multiple Where clause Query in Laravel.
- How to use custom table in Laravel Model?
- What is the purpose of the Eloquent cursor() method in Laravel
- Paginating records in Laravel
- How to get records between two date in Laravel using eloquent
- Call to a member function connection() on null Laravel Lumen
Laravel interview Questions © 2019 - Designed by PSD to HTML