MySQL 8.0

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

SELECT VERSION();


VERSION()


8.0.25


DROP TABLE IF EXISTS `tbl_table`;

CREATE TABLE IF NOT EXISTS `tbl_table` (
  `random_point` GEOMETRY
);
SET @`SRID` := 4326;

INSERT INTO `tbl_table`
VALUES
  (ST_GeomFromText('POINT(-30 -31)', @`SRID`)),
  (ST_GeomFromText('POINT(-32 -33)', @`SRID`)),
  (ST_GeomFromText('POINT(-60 -61)', @`SRID`)),
  (ST_GeomFromText('POINT(-62 -63)', @`SRID`));
SELECT
  ST_AsGeoJSON(`random_point`) `geojson`,
  ST_Latitude(`random_point`) `latitude`,
  ST_Longitude(`random_point`) `longitude`,
  ST_X(`random_point`) `x`,
  ST_Y(`random_point`) `y`
FROM `tbl_table`;


geojson
latitude
longitude
x
y


{"type": "Point", "coordinates": [-31.0, -30.0]}
-30
-30.999999999999996
-30
-30.999999999999996

{"type": "Point", "coordinates": [-33.0, -32.0]}
-32
-33
-32
-33

{"type": "Point", "coordinates": [-61.0, -60.0]}
-60
-61.00000000000001
-60
-61.00000000000001

{"type": "Point", "coordinates": [-63.0, -62.0]}
-61.99999999999999
-63
-61.99999999999999
-63

geojson	latitude	longitude	x	y
{"type": "Point", "coordinates": [-31.0, -30.0]}	-30	-30.999999999999996	-30	-30.999999999999996
{"type": "Point", "coordinates": [-33.0, -32.0]}	-32	-33	-32	-33
{"type": "Point", "coordinates": [-61.0, -60.0]}	-60	-61.00000000000001	-60	-61.00000000000001
{"type": "Point", "coordinates": [-63.0, -62.0]}	-61.99999999999999	-63	-61.99999999999999	-63