MySQL (5.1) SELECT WHERE HAVING Median Value

[big_nerd]

Hello All,

I have a Postal Code Database (purchased)

I want to extract 1 of each city (perhaps in a list of cities but that is not important)

I need to grab the record that is the closest to City Center as possible (Geographically)

The idea is to state How close a provided Lat/Long is to its surrounding cities, rather than relying on long queries or such.

The PHP is already in place but I want to speed it up by using a smaller table.

I don't want to randomly select a lat / long from a city as it could be at the far east end, and technically, another city can be closer if you are in the far west end.

Any help / ideas would be great, rather than parsing it all in PHP, looking for a query that can be re-used when adding new cities to our database.

Thanks in advance.