I have a zip code table that has the zip code, city, state and various other info in each row. The problem is that if I pull up all the cities in a zip code (say 33308) I get the same city spelled twice like this:
Fort Lauderdale Ft Lauderdale Laud By Sea Lauderdale By The Sea Oakland Park Oakland Pk Sea Ranch Lakes Sea Ranch Lks
The table looks like this:
zip_code varchar(5) lat float lon float city varchar(100) state_prefix varchar(100) county varchar(100) country varchar(100) population varchar(255) landarea varchar(255)
Because zip codes can span cities, counties and states, there are over 79,000 rows in this table!
I should also say I have no idea how many city names are messed up or how to find the ones that are messed up.
So the big question is this: What is the best strategy for fixing the city names in the database?