ST_DISTANCE

Calculates the shortest distance between two geometries. Returns the minimum Euclidean distance between any two points in the geometries.

Syntax

ST_DISTANCE(g1,g2)

Description

Returns the distance between two geometries, or null if not given valid inputs.

Example

SELECT ST_Distance(POINT(1,2),POINT(2,2));
+------------------------------------+
| ST_Distance(POINT(1,2),POINT(2,2)) |
+------------------------------------+
|                                  1 |
+------------------------------------+

_{This page is licensed: CC BY-SA / Gnu FDL}