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

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

Laravel eloquent query methods example; 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
  • orWhere() Function
  • WhereBetween Function
  • WhereNotBetween Function
  • WhereIn() Function
  • WhereNull() Function
  • WhereNotNull() Function
  • WhereNotIn() Function
  • WhereDate() Function
  • WhereMonth() Function
  • WhereDay() Function
  • WhereYear() Function
  • WhereTime() Function
  • WhereColumn() Function
  • WhereRaw() Function
  • OrderBy Function
  • OrderBy Function
  • SelectRaw() Function
  • HavingRaw() Function
  • Laravel Pluck () Function
  • Laravel Delete () Functions

Where() Function

Let’s see the laravel where() eloquent query example; as follows:

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

orWhere() Function

Let’s see the laravel orWhere() eloquent query example; as follows:

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

WhereBetween Function

Let’s see the laravel whereBetween() eloquent query example; as follows:

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

WhereNotBetween Function

Let’s see the laravel whereNotBetween() eloquent query example; as follows:

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

WhereIn() Function

Let’s see the laravel whereIn() eloquent query example; as follows:

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

WhereNull() Function

Let’s see the laravel whereNull() eloquent query example; as follows:

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

WhereNotNull() Function

Let’s see the laravel whereNotNull() eloquent query example; as follows:

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

WhereNotIn() Function

Let’s see the laravel whereNotIn() eloquent query example; as follows:

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

WhereDate() Function

Let’s see the laravel whereDate() eloquent query example; as follows:

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

WhereMonth() Function

Let’s see the laravel whereMonth() eloquent query example; as follows:

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

WhereDay() Function

Let’s see the laravel whereDay() eloquent query example; as follows:

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

WhereYear() Function

Let’s see the laravel whereYear() eloquent query example; as follows:

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

WhereTime() Function

Let’s see the laravel whereTime() eloquent query example; as follows:

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

WhereColumn() Function

Let’s see the laravel whereColumn() eloquent query example; as follows:

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

WhereRaw() Function

Let’s see the laravel whereRaw() eloquent query example; as follows:

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

OrderBy Function

Let’s see the laravel orderBy() eloquent query example; as follows:

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

SelectRaw() Function

Let’s see the laravel selectRaw() eloquent query example; as follows:

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

HavingRaw() Function

Let’s see the laravel havingRaw() eloquent query example; as follows:

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

Laravel Pluck () Function

Let’s see the laravel pluck() eloquent query example; as follows:

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

Laravel Delete () Functions

Let’s see the laravel delete() eloquent query example; as follows:

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

Recommended Laravel Tutorials

Recommended:-Laravel Try Catch

AuthorAdmin

Greetings, I'm Devendra Dode, a full-stack developer, entrepreneur, and the proud owner of Tutsmake.com. My passion lies in crafting informative tutorials and offering valuable tips to assist fellow developers on their coding journey. Within my content, I cover a spectrum of technologies, including 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. Whether you're starting out or looking for advanced examples, I provide step-by-step guides and practical demonstrations to make your learning experience seamless. Let's explore the diverse realms of coding together.

Leave a Reply

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