Laravel selectRaw() query example; In this tutorial, you will learn in detail how to write select raw and select DB raw query in laravel. And as well as learn, how to use selectRaw with joined table data.
You can use the laravel selectRaw eloquent method to building query in laravel apps. And also use laravel select raw with multiple conditions in eloquent queries.
So, let’s see following examples that will help you how to use selectRaw() eloquent query in laravel:
- Example 1: Laravel selectRaw Query using Model
- Example 2: selectRaw Query using Query Builder
- Example 3: Laravel selectRaw with joined table data
Example 1: Laravel selectRaw Query using Model
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
class UserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$users = User::select("*")
->selectRaw('amount + ? as amount_with_bonus', [500])
->get();
dd($users);
}
}
When you dump the above given selectRaw query you will get the following SQL query:
select *, amount + ? as amount_with_bonus from `users`
Recommended:- Laravel Where Multiple Condition
Example 2: selectRaw Query using Query Builder
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
use DB;
class UserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$users = DB::table('users')->select("*")
->select('*', DB::raw('amount + 500 as amount_with_bonus'))
->get();
dd($users);
}
}
When you dump the above given selectRaw query you will get the following SQL query:
select *, amount + ? as amount_with_bonus from `users`
Recommended:- Laravel – whereIn Eloquent Query Example
Example 3: Laravel selectRaw with joined table data
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
use DB;
class UserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$users = DB::table('users')
->where('active','true')
->join('user_types', 'users.user_type_id', '=', 'user_types.id')
->groupBy('user_type_id','user_types.name')
->selectRaw('sum(total) as sum, user_types.name as name')
->pluck('sum','name');
dd($users);
}
}
Recommended Laravel Tutorials
Recommended:-Laravel PHP Artisan Serve Not Working
Recommended:-Laravel Get Record Last Week, Month, 15 Days, Year
Recommended:-Laravel where Day, Date, Month, Year, Time, Column
Recommended:-Laravel Try Catch
Recommended:-Laravel Eloquent whereRaw Query Example
Recommended:-How to Get Random Records in Laravel
Recommended:-Laravel Clear Route, Config and View Cache Commands
Recommended:-Laravel InsertOrIgnore Example
Recommended:-Laravel whereIn, whereNotIn With SubQuery Example
Recommended:-Laravel Eloquent withSum() and withCount() Tutorial
Recommended:-Laravel Where Null and Where Not Null Query
Recommended:-Laravel Eloquent firstWhere() Example
Recommended:-Laravel Group by Example
Recommended:-Laravel Order by Example
Recommended:-Laravel 8 Google Autocomplete Address Tutorial
Recommended:-Laravel 8 Vue JS Post Axios Request Tutorial
Recommended:-Laravel 8 Vue JS File Upload Tutorial Example
Recommended:-Laravel 8 Vue JS Live Search Example
Recommended:-Laravel 8 Vue Js Infinity Page Scroll Example
Recommended:-How to implement Datatables with Vuejs And Laravel 8
Recommended:-Laravel 8 Google Autocomplete Address Tutorial
Recommended:-Laravel 8 Vue JS CRUD App
Recommended:-Vue JS And Laravel 8 Like Dislike Tutorial Example
