Returns the X-coordinate of a Point geometry. This function extracts the horizontal coordinate value as a double-precision number.
SET @pt = 'Point(56.7 53.34)';
SELECT X(GeomFromText(@pt));
+----------------------+
| X(GeomFromText(@pt)) |
+----------------------+
| 56.7 |
+----------------------+