In this tutorial you will learn about the Laravel Eloquent whereRaw Query Example and its application with practical example.
In this laravel where raw query example tutorial I’ll show you how to write whereraw and where DB raw query in laravel. In this article you will also learn to use the laravel whereRaw eloquent method to building query in laravel. I’ll also show you how to use laravel where raw with multiple conditions in eloquent queries.
Laravel whereRaw Query using Model
In this example I’ll show you how to use laravel whereRaw query in laravel model. In laravel you can use whereRaw with model as following:
|
1 2 3 4 5 6 |
public function index() { $users = User::whereRaw('YEAR(created_at) = ?', [date('Y')])->get(); dd($users); } |
The above given whereRaw query you will get the following SQL query:
|
1 |
select * from `users` where YEAR(created_at) = ? |
whereRaw Query using Query Builder
In this example I’ll show you how to use laravel whereRaw query using Query Builder. In laravel you can use whereRaw with Query Builder as following:
|
1 2 3 4 5 6 |
public function index() { $users = DB::table('users')->whereRaw('YEAR(created_at) == ? AND MONTH(created_at) == ?', [date('Y'),date('m')])->get(); dd($users); } |
The above given whereRaw query you will get the following SQL query:
|
1 |
select * from `users` where YEAR(created_at) == ? AND MONTH(created_at) == ? |
