MariaDB 10.4

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

SELECT VERSION();


VERSION()


10.4.26-MariaDB-1:10.4.26+maria~deb10-log


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`));

Records: 4  Duplicates: 0  Warnings: 0


SELECT
  ST_AsGeoJSON(`random_point`) `geojson`,
  ST_X(`random_point`) `x`,
  ST_Y(`random_point`) `y`
FROM `tbl_table`;


geojson
x
y


{"type": "Point", "coordinates": [-30, -31]}
-30
-31

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

{"type": "Point", "coordinates": [-60, -61]}
-60
-61

{"type": "Point", "coordinates": [-62, -63]}
-62
-63

geojson	x	y
{"type": "Point", "coordinates": [-30, -31]}	-30	-31
{"type": "Point", "coordinates": [-32, -33]}	-32	-33
{"type": "Point", "coordinates": [-60, -61]}	-60	-61
{"type": "Point", "coordinates": [-62, -63]}	-62	-63