ST_AsText,ST_AsWKT
Descriptionβ
Converts a geometric figure to WKT (Well Known Text) format.
Syntaxβ
VARCHAR ST_AsText(GEOMETRY geo)
Examplesβ
MySQL > SELECT ST_AsText(ST_Point(24.7, 56.7));
+---------------------------------+
| st_astext(st_point(24.7, 56.7)) |
+---------------------------------+
| POINT (24.7 56.7) |
+---------------------------------+
keywordβ
ST_ASTEXT,ST_ASWKT,ST,ASTEXT,ASWKT