How to SELECT rows closest to value

[M5]

Simply put, I have a table of ~800,000 records containing, among  
other things, latitude and longitude values. Given a lat/lng pair, I  
would like to SELECT from this table the 10 rows containing latitude/ 
longitude values closest to the given lat/lng pair. Possible?

...Rene

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]