Топ-100
 

MBRCONTAINS

RDBMS Type: MySQL
Topic

MBRContains(g1, g2)

Returns 1 or 0 to indicate whether the minimum bounding rectangle of g1
contains the minimum bounding rectangle of g2. This tests the opposite
relationship as MBRWithin().

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

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

Example

mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
mysql> SET @g2 = ST_GeomFromText('Point(1 1)');
mysql> SELECT MBRContains(@g1,@g2), MBRWithin(@g2,@g1);
+----------------------+--------------------+
| MBRContains(@g1,@g2) | MBRWithin(@g2,@g1) |
+----------------------+--------------------+
| 1 | 1 |
+----------------------+--------------------+