MBREquals¶
TL;DR¶
MBREquals returns whether two geometries have equal minimum bounding rectangles.
Syntax¶
MBREquals(geom1, geom2)
Arguments¶
geom1 and geom2 are GEOMETRY values.
Return Value¶
Returns BOOL.
Usage Notes¶
Equal MBRs do not require the full geometries to be spatially equal.
Examples¶
DROP DATABASE IF EXISTS geo_mbrequals_demo;
CREATE DATABASE geo_mbrequals_demo;
USE geo_mbrequals_demo;
SELECT MBREquals(ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0))'), ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0))')) AS equal_mbr;
DROP DATABASE geo_mbrequals_demo;