On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

### 18.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)

MySQL provides several functions that test relations between minimal bounding rectangles of two geometries `g1` and `g2`. The return values 1 and 0 indicate true and false, respectively.

• `MBRContains(g1,g2)`

Returns 1 or 0 to indicate whether the Minimum Bounding Rectangle of `g1` contains the Minimum Bounding Rectangle of `g2`.

```mysql> `SET @g1 = GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');`
mysql> `SET @g2 = GeomFromText('Point(1 1)');`
mysql> `SELECT MBRContains(@g1,@g2), MBRContains(@g2,@g1);`
----------------------+----------------------+
| MBRContains(@g1,@g2) | MBRContains(@g2,@g1) |
+----------------------+----------------------+
|                    1 |                    0 |
+----------------------+----------------------+
```
• `MBRDisjoint(g1,g2)`

Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles of the two geometries `g1` and `g2` are disjoint (do not intersect).

• `MBREqual(g1,g2)`

Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles of the two geometries `g1` and `g2` are the same.

• `MBRIntersects(g1,g2)`

Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles of the two geometries `g1` and `g2` intersect.

• `MBROverlaps(g1,g2)`

Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles of the two geometries `g1` and `g2` overlap.

• `MBRTouches(g1,g2)`

Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles of the two geometries `g1` and `g2` touch.

• `MBRWithin(g1,g2)`

Returns 1 or 0 to indicate whether the Minimum Bounding Rectangle of `g1` is within the Minimum Bounding Rectangle of `g2`.

```mysql> `SET @g1 = GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');`
mysql> `SET @g2 = GeomFromText('Polygon((0 0,0 5,5 5,5 0,0 0))');`
mysql> `SELECT MBRWithin(@g1,@g2), MBRWithin(@g2,@g1);`
+--------------------+--------------------+
| MBRWithin(@g1,@g2) | MBRWithin(@g2,@g1) |
+--------------------+--------------------+
|                  1 |                  0 |
+--------------------+--------------------+
```

 Published under the terms of the GNU General Public License Design by Interspire