The following table describes the supported GIS and geometry functions.
| Function | Description |
|---|---|
ST_Area |
Returns the area of a geometry. |
ST_AsText |
Returns the Well-Known Text (WKT) representation of a geometry. |
ST_Buffer |
Returns a geometry representing all points within a specified distance from the original geometry. |
ST_Centroid |
Returns the centroid (geometric center) of a geometry. |
ST_Contains |
Determines whether one geometry contains another. |
ST_Distance |
Returns the distance between two geometries. |
ST_GeomFromText |
Creates a geometry from a WKT representation. |
ST_Intersects |
Determines whether two geometries intersect. |
ST_Length |
Returns the length of a geometry. |
ST_Within |
Determines whether one geometry is entirely within another. |
For more information, see the MySQL documentation: Spatial Function Reference.