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.
Last updated
3 years ago.
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!
Laravel
Laravel News
Laracasts
Laravel Podcast