Hi, i have been developing a site that stores spatial data in mysql database, like that of buildings, gardens, etc. in the form of polygons (latitudes and longitudes).

I want to know how to retrieve polygon data in mysql.

I have seen this sample query to insert a polygon data: http://amper.110mb.com/SPAT/mysql_initgeometry2.htm

But now i want to know how to retrieve data from the table, based on certain constraints like:

"where latitude < 9.33 and longitude > 22.4" Also how do i find whether a point lies inside or outside of a polygon