Laravel where Day, Date, Month, Year, Time, Column

Laravel where Day, Date, Month, Year, Time, Column

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();

AuthorAdmin

My name is Devendra Dode. I am a full-stack developer, entrepreneur, and owner of Tutsmake.com. I like writing tutorials and tips that can help other developers. I share tutorials of PHP, Python, Javascript, JQuery, Laravel, Livewire, Codeigniter, Node JS, Express JS, Vue JS, Angular JS, React Js, MySQL, MongoDB, REST APIs, Windows, Xampp, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL and Bootstrap from a starting stage. As well as demo example.

Leave a Reply

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