ST_X

Description

Syntax

DOUBLE ST_X(POINT point)

When point is a valid POINT type, the corresponding X coordinate value is returned.

example

1. mysql> SELECT ST_X(ST_Point(24.7, 56.7));
2. +----------------------------+
3. | st_x(st_point(24.7, 56.7)) |
4. +----------------------------+
5. |                       24.7 |
6. +----------------------------+

keywords

ST_X,ST,X