Laravel 5.7 WhereRaw|WhereDate|WhereIn Methods

In this laravel 5.8,5.7 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', 'tutsmake')
->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

Spread the love

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *