top of page
CerebroSQL

MySQL: 

ST_ENDPOINT

ST_EndPoint(ls)

Returns the Point that is the endpoint of the LineString value ls.

ST_EndPoint() 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_EndPoint(ST_GeomFromText(@ls)));
+----------------------------------------------+
| ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))) |
+----------------------------------------------+
| POINT(3 3) |
+----------------------------------------------+

bottom of page