top of page
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