Skip to content

Instantly share code, notes, and snippets.

@hmcclungiii
Last active March 6, 2016 21:28
Show Gist options
  • Save hmcclungiii/833815486c2ec03e490d to your computer and use it in GitHub Desktop.
Save hmcclungiii/833815486c2ec03e490d to your computer and use it in GitHub Desktop.
An SQL Query to Add the 50 US States into the Wordpress wp_terms (Categories) Table
INSERT INTO `wp_terms`(`name`, `slug`, `term_group`) VALUES
('AK - Alaska', 'ak', 0),
('AZ - Arizona', 'az', 0),
('AR - Arkansas', 'ar', 0),
('CA - California', 'ca', 0),
('CO - Colorado', 'co', 0),
('CT - Connecticut','ct', 0),
('DE - Delaware','de', 0),
('FL - Florida','fl', 0),
('GA - Georgia','ga', 0),
('HI - Hawaii','hi', 0),
('ID - Idaho','id', 0),
('IL - Illinois','il', 0),
('IN - Indiana','in', 0),
('IA - Iowa','ia', 0),
('KS - Kansas','ks', 0),
('KY - Kentucky','ky', 0),
('LA - Louisiana','la', 0),
('ME - Maine','me', 0),
('MD - Maryland','md', 0),
('MA - Massachusetts','ma', 0),
('MI - Michigan','mi', 0),
('MN - Minnesota','mn', 0),
('MS - Mississippi','ms', 0),
('MO - Missouri','mo', 0),
('MT - Montana','mt', 0),
('NE - Nebraska','ne', 0),
('NV - Nevada','nv', 0),
('NH - New Hampshire','nh', 0),
('NJ - New Jersey','nj', 0),
('NM - New Mexico','nm', 0),
('NY - New York','ny', 0),
('NC - North Carolina','nc', 0),
('ND - North Dakota','nd', 0),
('OH - Ohio','oh', 0),
('OK - Oklahoma','ok', 0),
('OR - Oregon','or', 0),
('PA - Pennsylvania','pa', 0),
('RI - Rhode Island','ri', 0),
('SC - South Carolina','sc', 0),
('SD - South Dakota','sd', 0),
('TN - Tennessee','tn', 0),
('TX - Texas','tx', 0),
('UT - Utah','ut', 0),
('VT - Vermont','vt', 0),
('VA - Virginia','va', 0),
('WA - Washington','wa', 0),
('WV - West Virginia','wv', 0),
('WI - Wisconsin','wi', 0),
('WY - Wyoming','wy', 0);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment