Geometric Functions List : Geometric Functions « Geometric « SQL / MySQL

1. SQL / MySQL
2. Geometric
3. Geometric Functions

Geometric Functions List

     
Function                     Description
CONTAINS(G1,G2)              TRUE if G2 is completely within the bounding box of G1.
WITHIN(G1,G2)                TRUE, if G1 is completely within the bounding box of G2.
CROSSES(G1,G2)               G1 and G2 do not cross.
EQUALS(G1,G2)                TRUE if the objects are identical.
INTERSECTS(G1,G2)            TRUE if G1 and G2 touch or overlap.
OVERLAPS(G1,G2)              TRUE if G1 and G2 overlap.
TOUCHES(G1,G2)               TRUE if G1 and G2 touch.
DISJOINT(G1,G2)              TRUE if G1 and G2 neither touch nor overlap.

   
    
    
    
    
  

Related examples in the same category