MBRContains¶
TL;DR¶
MBRContains returns whether the first geometry’s minimum bounding rectangle contains the second’s.
Syntax¶
MBRContains(geom1, geom2)
Arguments¶
geom1 and geom2 are GEOMETRY values.
Return Value¶
Returns BOOL.
Usage Notes¶
This predicate compares minimum bounding rectangles, not the complete shapes of the input geometries.
Examples¶
DROP DATABASE IF EXISTS geo_mbrcontains_demo;
CREATE DATABASE geo_mbrcontains_demo;
USE geo_mbrcontains_demo;
SELECT MBRContains(ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0))'), ST_GeomFromText('POLYGON((2 2,4 2,4 4,2 4,2 2))')) AS contains_mbr;
DROP DATABASE geo_mbrcontains_demo;