Eloquent doesn't recognize my alias

I've a query to search users with certain distance :

$q->addSelect(DB::raw(
    '( 6371 * acos(cos(radians(' . Auth::user()->latitude . '))' .
        '* cos( radians( users.latitude ) )' .
        '* cos( radians( users.longitude )' .
        '- radians(' . Auth::user()->longitude . ') )' .
        '+ sin( radians(' . Auth::user()->latitude . ') )' .
        '* sin( radians( users.latitude ) ) ) ) as distance'
));
$q->having('distance', '<', $search->distance);

I get this error : Column not found: 1054 Unknown column 'distance' in 'having clause'.

When I run the query in PhpMyAdmin with the return of $q->toSql();, my query works?!

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2IiuZkV
via IFTTT