Hi I have been testing mysql's GIS support for quite some time now. I have one question. Suppose I execute this simple query:
select * from node where MRBWithin(node.shape_geo, LINESTRING(0 0, 200 200)); This will select all node records that are bounded in in the ractangle (0,0), (0,200), (200,200) and (200,0). Is there anyway to get mysql to return the results in the order of 'closest to the center point of MBR'? Ie the center point (100,100). The result set would be something like: (101, 105) (90, 80) (20, 35) (199,173) Regards Keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
