Any idea how to find a US county, based on city, state, and zip?

Giganews Newsgroups
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.

Replies