SELECT * from polygons WHERE bounds CONTAINS(SELECT geom_point from points)
Can someone help me out with the syntax? Bounds will always be a rectangular polygon and everything is in lon/lat. I could just check that each points lat/lng is between the min/max lat/lng of each polygon - but I cannot figure out the syntax to get MYSQL to loop / check all polys vs all points.
Thanks in advance.