Breaking News: Grepper is joining You.com. Read the official announcement!

see locations within radius mysql

Svetla Syrimis answered on June 28, 2022 Popularity 1/10 Helpfulness 1/10

answer see locations within radius mysql

see locations within radius mysql

Comment

DELIMITER $$

CREATE FUNCTION calcDistance(lat FLOAT, lng FLOAT, pnt_lat FLOAT, pnt_lng FLOAT)
    RETURNS FLOAT
BEGIN

    DECLARE dist FLOAT;
    SET dist =
          3959 * acos(
                cos(radians(pnt_lat))
                * cos(radians(lat))
                * cos(radians(lng) - radians(pnt_lng))
            + sin(radians(pnt_lat))
                    * sin(radians(lat))
          );

    RETURN dist;

END

Popularity 1/10 Helpfulness 1/10 Language sql

Source: gis.stackexchange.com

Tags: mysql radius sql

Link to this answer
Share Copy Link