top of page
CerebroSQL

MySQL: 

ST_STARTPOINT

ST_StartPoint(ls)

Returns the Point that is the start point of the LineString value ls.

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

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

Example

mysql> SET @ls = 'LineString(1 1,2 2,3 3)';
mysql> SELECT ST_AsText(ST_StartPoint(ST_GeomFromText(@ls)));
+------------------------------------------------+
| ST_AsText(ST_StartPoint(ST_GeomFromText(@ls))) |
+------------------------------------------------+
| POINT(1 1) |
+------------------------------------------------+

bottom of page