In this laravel eloquent query methods tutorial. In this tutorial, you will learn laravel eloquents methods like where, whereDate, whereRaw, whereMonth, whereYear, whereIn, whereNotIn, whereNull, whereNotNull, whereTime, havingRaw, whereBetween, whereNotBetween and laravel pluck.

Laravel All Where Eloquent Queries 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();