|Functions / Geometry Predicate Functions (boolean)|
Determines if one geometry object intersects another geometry object.
MI_Intersects ( geometry1, geometry2 )
geometry1 and geometry2 are geometry objects (or expressions).
Determines if the specified box intersects any of the country geometries.
select MI_Intersects(MI_Box(-13.36676789,8.05796847,79.06334219,62.70540978,'epsg:4326'),[Geometry_Column]) from countries where country = ANY ('Mauritania','Mali','Algeria')
Returns true if geometry1 intersects geometry2, false otherwise. If either geometry1 or geometry2 are null, false is returned. The function is performed using the coordinate system of the first argument (geometry1).