SQL: Full Name Lookup for States and Provinces for the US and Canada
Happy New Year! Marketing Technology finds and reports on the latest technology that will enable your business to effectively market to your audience, for acquisition or retention strategies. Subscribe now the Marketing Technology Blog RSS feed or to the Marketing Technology Email to have new content sent directly to your inbox. You'll also find my other business blog helpful, Social Media Domination.
While working on the Wild Birds Unlimited Mapping project this weekend, I needed to make a table in MySQL that translated the 2-digit country and state abbreviations to a full name. I’m sure this is something that is needed quite a bit, so I’ve put the SQL file up on my server for download.
Download SQL for State and Province Abbreviations for the United States and Canada. You can right-click and save as if you’d like the file locally. I’ve also added an Index on both the country and state ids to improve performance.
Hat tip to Brian who had a nice CSV I was able to work from.
No comments yet.