Mega Code Archive

 

Categories / MySQL / Geometric

 

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.