ST_X
Description
Syntax:
DOUBLE ST_X(POINT point)
If point is a valid POINT type, this function will return the corresponding X coordinate value.
Example
mysql> SELECT ST_X(ST_Point(24.7, 56.7));
+----------------------------+
| st_x(st_point(24.7, 56.7)) |
+----------------------------+
| 24.7 |
+----------------------------+Keywords
ST_X,ST,X