Address: 310 Grau Drive, Fremont, CA Geo Coordinates: Lat = , Lon = Distance = 12767.074728966 Distance SQL : SELECT * , acos((sin(0) * sin(0.65610728782242)) + (cos(0) * cos(0.65610728782242)) * (cos(0 - -2.1290467890771))) * 6371.0 as distance FROM product_details HAVING ( distance < 8 ) ORDER BY distance ASC SELECT *, (ST_Distance(POINT(, ), product_details.coordinates) / 1609.344) AS distance from product_details having (distance < 8) ORDER BY distance ASC