|Subject:||Any idea how to find a US county, based on city, state, and zip?|
|Posted by:||Jason C (jwcarlt…@gmail.com)|
|Date:||Sun, 20 Nov 2011|
I have a MySQL database with about 28,000 rows. I have the city, state, and zip, but I need to insert a column for the county that they are in.
I can do this manually, no problem, but 28,000 is a lot to sort through one at a time! Any suggestions on how I might make it a bit more automated?
FWIW, I can do it in any programming language necessary, since this is just a one-time thing.