How to use paginate in this query laravel

How to use pagination for this query ?

$listings = DB::table('listings')
                ->selectRaw('*, ( 3959 * acos( cos( radians(' . $lat . ') ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(' . $lng . ') ) + sin( radians(' . $lat .') ) * sin( radians(latitude) ) ) ) AS distance')
                ->having('distance', '<', $distance)
                ->orderBy('distance')->paginate(10);

I tried paginate(10) it doesnt work.

the error : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'distance' in 'having clause' (SQL: select count(*) as aggregate from listings having distance < 5)

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