ST_X(p [, new_x_val])

With a single argument representing a valid Point object p, ST_X()
returns the X-coordinate value of p as a double-precision number. The X
coordinate is considered to refer to the axis that appears first in the
Point spatial reference system (SRS) definition.

With the optional second argument, ST_X() returns a Point object like
the first argument with its X coordinate equal to the second argument.
If the Point object has a geographic SRS, the second argument must be
in the proper range for longitude or latitude values.

ST_X() handles its arguments as described in the introduction to this
section.

URL: https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html

