After developing database driven websites for awhile, a few common issues come up.

USA! USA!

One of them is getting all the states of the US & their abbreviations into the database, most likely for some sort of user registration. This was exactly the problem I faced a little while ago.

And like anyone who learned the majority of their internet skills on the internet itself, the first thing I did was a google search, and found this blog post at firewall pro.

It contains a CSV and SQL tables to easily input into your database all the U.S. states and their abbreviations, so you don’t have to.

Thanks goes to Scott for publishing the work so we can get back to actual programming!