DOUBLE ST_X(POINT point)
When point is a valid POINT type, the corresponding X coordinate value is returned.
mysql> SELECT ST_X(ST_Point(24.7, 56.7)); +----------------------------+ | st_x(st_point(24.7, 56.7)) | +----------------------------+ | 24.7 | +----------------------------+
ST_X,ST,X