top of page
MySQL:
ST_EQUALS
ST_Equals(g1, g2)
Returns 1 or 0 to indicate whether g1 is spatially equal to g2.
ST_Equals() handles its arguments as described in the introduction to
this section, except that it does not return NULL for empty geometry
arguments.
URL: https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
Example
mysql> SET @g1 = Point(1,1), @g2 = Point(2,2);
mysql> SELECT ST_Equals(@g1, @g1), ST_Equals(@g1, @g2);
+---------------------+---------------------+
| ST_Equals(@g1, @g1) | ST_Equals(@g1, @g2) |
+---------------------+---------------------+
| 1 | 0 |
+---------------------+---------------------+
bottom of page