Convert MySQL query using Laravel Query Builder

Question

I have a question regarding a MySQL query.
I would like to know how to create the same query using Laravel QUERY Builder

SELECT count( * ) as total_record FROM `player_games` WHERE team_score <  rival_score

Thanks

just read laravel document.

Devsi Odedra
– Devsi Odedra

2018-12-07 13:29:23 +00:00
Commented Dec 7, 2018 at 13:29 — Devsi Odedra
– Devsi Odedra, Commented Dec 7, 2018 at 13:29
laravel-news.com/convert-sql-laravel-builder-orator

Ugur Kazdal
– Ugur Kazdal

2018-12-07 13:41:47 +00:00
Commented Dec 7, 2018 at 13:41 — Ugur Kazdal
– Ugur Kazdal, Commented Dec 7, 2018 at 13:41

Jignesh Joisar · Accepted Answer · 2018-12-07 13:55:22Z

2

try this one

$query = "SELECT count( * ) as total_record FROM `player_games` WHERE team_score <  rival_score";

$count = \DB::select(\DB::raw($query));

secod way

DB::table('player_games')->where('team_score','<','rival_score')->count();

edited Dec 7, 2018 at 13:55

answered Dec 7, 2018 at 13:29

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user10087184 Over a year ago

Hi, thanks...the result is [{"total_record":1}]...I would like to have 1 instead.

Jignesh Joisar Over a year ago

@user10087184 try second way

Amitoz Deol · Accepted Answer · 2018-12-07 13:36:11Z

0

$total_record = DB::table('player_games')->where('team_score', '<', 'rival_score')
                         ->count();

answered Dec 7, 2018 at 13:36

Amitoz Deol

4425 silver badges17 bronze badges

Comments

DaFois · Accepted Answer · 2018-12-07 13:36:11Z

0

in Laravel Query Builder you can write this:

$player_games = DB::table('player_games')->where('team_score','<', 'rival_score')->count();

Reference: https://laravel.com/docs/5.7/queries

answered Dec 7, 2018 at 13:36

DaFois

2,2238 gold badges28 silver badges47 bronze badges

Comments

apokryfos · Accepted Answer · 2018-12-07 15:07:02Z

0

There's a subtle thing here that you need to be aware of:

DB::table('player_games')
     ->where('team_score','<',\DB::raw('`rival_score`'))
     ->count();

The reason why you need \DB::raw is because if you don't then the right-hand side of the where will be automatically assumed to be a value and be passed as a binding, however you need to pass it as a raw DB expression to indicate that it's actually a column name. The backticks are added because it's good to escape the column names.

answered Dec 7, 2018 at 15:07

apokryfos

40.9k11 gold badges85 silver badges128 bronze badges

1 Comment

Namoshek Over a year ago

There is a built-in to avoid the dirty hack with backticks (which is not DBMS agnostic by the way): $query->whereColumn('left_column', '<', 'right_column')

Collectives™ on Stack Overflow

Convert MySQL query using Laravel Query Builder

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related