Conditional query based on aggregation fields

Question

Given I have this simple query:

$builder = User::select(DB::raw('users.age as age, users.restrict as restrict'))
               ->whereBetween("user.id",$id)
               ->get();

Is there any way to get users where age is lower than restrict column ?

Alexey Mezenin · Accepted Answer · 2018-02-16 08:57:21Z

1

Since both age and restrict are columns, use the whereColumn() method. Also, it looks like you want to get only records with IDs that are in $ids array. So, use whereIn():

User::whereColumn('age', '<', 'restrict')->whereIn('id', $ids)->get();

answered Feb 16, 2018 at 8:57

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

Comments

Mahdi Younesi · Accepted Answer · 2018-02-16 08:44:46Z

0

This ->where("user_id", $id) returns only one user! does not it ?

$users = DB::table('users')->whereBetween("id",$ids)
                           ->where("age",'<','restrict')->get();

Or

$users = User::where("age",'<','restrict')->whereBetween("id",$ids)->get();

edited Feb 16, 2018 at 8:44

answered Feb 16, 2018 at 8:42

Mahdi Younesi

7,5592 gold badges23 silver badges54 bronze badges

1 Comment

PrStandup Over a year ago

my bad that should be whereBetween some array of id's, I tried that unknown column

Collectives™ on Stack Overflow

Conditional query based on aggregation fields

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related