having clause in mysql query error

Question

I am trying to the fetch nearest location according lat and lng but I want to add having distance < 5 clause in query.

But where I can use.??

select p.id, p.name, p_i.image as image, 
( 3959 * acos( cos( radians(26.916279) ) * 
cos( radians( lat ) ) * 
cos( radians( lng ) - radians(75.8082) ) + 
sin( radians(26.916279) ) * 
sin( radians( lat ) ) ) ) AS distance 
from `places` as p 
inner join `place_images` as p_i 
on p.`id` = p_i.`place_id` 
where p.`city_id` = '1' 
and p.status = 'active' 
and p_i.display_order = '1' 
limit 0, 5

current result

Answer 1

You can add having clause at last, just before limit

select p.id, p.name, p_i.image as image, ( 3959 * acos( cos( radians(26.916279) )
 * cos( radians( lat ) ) * cos( radians( lng ) - radians(75.8082) )
 + sin( radians(26.916279) ) * sin( radians( lat ) ) ) ) AS distance 
 from `places` as p inner join `place_images` as p_i on p.`id` = p_i.`place_id`
 where p.`city_id` = '1' and p.status = 'active' and p_i.display_order = '1' 
 HAVING distance < 5 limit 0, 5