HomeLanguagesLaravel whereRaw, whereIn, whereNotIn, OrderBy

Laravel whereRaw, whereIn, whereNotIn, OrderBy

In this laravel tutorial, When we do development, We want to filter some records using laravel inbuild Functions and methods. We would love to share with you many laravel where Function. As we know that laravel provide where, whereDate, whereRaw, whereMonth, whereYear, whereIn, whereNotIn, whereNull, whereNotNull, whereTime, havingRaw, whereBetween, whereNotBetween and laravel pluck.

Lets see the laravel methods :

Where() Function :

DB::table('users')
->where('id', 1)
->get();

orWhere() Function :

DB::table('users')
->where('id', '>', 100)
->orWhere('name', 'neveropen')
->get();

WhereBetween Function :

DB::table('users')
->whereBetween('id', [1, 100])->get();

WhereNotBetween Function :

DB::table('users')
->whereNotBetween('id', [1, 100])->get();

WhereIn() Function :

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

WhereNull() Function :

DB::table('users')
->whereNull('updated_at')
->get();

WhereNotNull() Function :

DB::table('users')
->whereNotNull('updated_at')
->get();

WhereNotIn() Function :

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

WhereDate() Function :

DB::table('users')
->whereDate('created_at', date('Y-m-d'))
->get();

WhereMonth() Function :

DB::table('users')
->whereMonth('created_at', '05')
->get();

WhereDay() Function :

DB::table('users')
->whereDay('created_at', '05')
->get();

WhereYear() Function :

DB::table('users')
->whereYear('created_at', '05')
->get();

WhereTime() Function :

DB::table('users')
->whereTime('created_at', '=', '1:20:45')
->get();

WhereColumn() Function :

DB::table('users')
->whereColumn('first_name', 'last_name')
->get();

WhereRaw() Function :

DB::table('orders')
->whereRaw('price > IF(state = "TX", ?, 100)', [200])
->get();

OrderBy Function :

 DB::table('users')
->orderBy('name', 'desc')
->get();

SelectRaw() Function :

DB::table('orders')
->selectRaw('price * ? as price_with_tax', [1.0825])
->get();

HavingRaw() Function :

DB::table('orders')
->select('orders', DB::raw('SUM(price) as total_amount'))
->groupBy('orders')
->havingRaw('SUM(price) > ?', [2500])
->get();

Laravel Pluck () Function:

DB::table('users')
->where('id', 1)
->pluck('name');

Laravel Delete () Functions:

DB::table('users')
->where('id', 1)
->delete();

If you want to know more laravel methods and functions go to https://laravel.com/docs/5.7/queries

RELATED ARTICLES

Most Popular

Dominic
32743 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7129 POSTS0 COMMENTS
Nicole Veronica
12258 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12341 POSTS0 COMMENTS
Shaida Kate Naidoo
7240 POSTS0 COMMENTS
Ted Musemwa
7501 POSTS0 COMMENTS
Thapelo Manthata
7219 POSTS0 COMMENTS
Umr Jansen
7189 POSTS0 COMMENTS