MySQL tutorial: ST_EQUALS [EN]
top of page
CerebroSQL

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