Bounding Box Functions : Bounding Box « Geometric « SQL / MySQL

1. SQL / MySQL
2. Geometric
3. Bounding Box

Bounding Box Functions

    
Function                    Description
MBRCONTAINS(G1,G2)          TRUE if the bounding box of G2 is completely within the bounding box of G1.
MBRWITHIN(G1,G2)            TRUE if the bounding box of G1 is completely within the bounding box of G2.
MBREQUAL(G1,G2)             TRUE if the bounding boxes are identical.
MBRINTERSECTS(G1,G2)        TRUE if the bounding boxes of G1 and G2 touch or overlap.
MBROVERLAPS(G1,G2)          TRUE if the bounding boxes of G1 and G2 overlap.
MBRTOUCHES(G1,G2)           TRUE if the bounding boxes of G1 and G2 touch.
MBRDISJOINT(G1,G2)          TRUE if the bounding boxes of G1 and G2 neither touch nor overlap.

   
    
    
    
  

Related examples in the same category