feature request mainly for support of location searches:
SELECT id, ( 3959 * acos( cos( radians(40) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-83) ) + sin( radians(40) ) * sin( radians( latitude ) ) ) ) AS distance FROM location HAVING distance < 100 ORDER BY distance LIMIT 0 , 20;
Thanks!
feature request mainly for support of location searches:
SELECT id, ( 3959 * acos( cos( radians(40) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-83) ) + sin( radians(40) ) * sin( radians( latitude ) ) ) ) AS distance FROM location HAVING distance < 100 ORDER BY distance LIMIT 0 , 20;
Thanks!