Even though I'm selecting a column as another column I cannot perform a query on the aliased column.
$users = User::select(DB::raw('*, age_when_created as age'))
->where(function($query) use ($slug, $tags, $country, $username, $like, $between) {
$query->where('age', 27);
// [...]
});
Calling this gives me a "undefined column in where clause" error. Obviously I'm planning to do some more to the aliased column so I cant just use the original field.
Just figured it out. You can't use where clauses on aggregates in MySQL. You need to use having()
instead.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community