top of page
CerebroSQL

MySQL: 

ST_DIFFERENCE

ST_Difference(g1, g2)

Returns a geometry that represents the point set difference of the
geometry values g1 and g2.

ST_Difference() handles its arguments as described in the introduction
to this section.

URL: https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html

Example

mysql> SET @g1 = Point(1,1), @g2 = Point(2,2);
mysql> SELECT ST_AsText(ST_Difference(@g1, @g2));
+------------------------------------+
| ST_AsText(ST_Difference(@g1, @g2)) |
+------------------------------------+
| POINT(1 1) |
+------------------------------------+

bottom of page