value AND b.longitude>givenvalue
LIMIT 0,5)
;
Thanks,
ViSolveDB Team
- Original Message -
From: "M5" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 03, 2007 7:30 AM
Subject: How to SELECT rows closest to value
Simply put, I have a table of ~800,000 records cont
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
