MySQL 5.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.5.62


CREATE FUNCTION geodist_sphere (
  src_lat DECIMAL(9,6), src_lon DECIMAL(9,6),
  dst_lat DECIMAL(9,6), dst_lon DECIMAL(9,6)
) RETURNS DECIMAL(6,2) DETERMINISTIC
BEGIN
 SET @dist := 6371 * 2 * ASIN(SQRT(
      POWER(SIN((src_lat - ABS(dst_lat)) * PI()/180 / 2), 2) +
      COS(src_lat * PI()/180) *
      COS(ABS(dst_lat) * PI()/180) *
      POWER(SIN((src_lon - dst_lon) * PI()/180 / 2), 2)
    ));
 RETURN @dist;
END;
select Geodist_sphere(59.871615914096544, 10.732875010123138,
59.28192441905507, 18.082728206254334)as IsOsloVstolgolm;


IsOsloVstolgolm


418.79