SQL update script to convert state names to ISO 3166-2 codes. Just rename the table/field names as needed.

convert-states.sql

UPDATE USER_INFO SET STATE='AL' WHERE STATE='Alabama';
UPDATE USER_INFO SET STATE='AK' WHERE STATE='Alaska';
UPDATE USER_INFO SET STATE='AZ' WHERE STATE='Arizona';
UPDATE USER_INFO SET STATE='AR' WHERE STATE='Arkansas';
UPDATE USER_INFO SET STATE='CA' WHERE STATE='California';
UPDATE USER_INFO SET STATE='CO' WHERE STATE='Colorado';
UPDATE USER_INFO SET STATE='CT' WHERE STATE='Connecticut';
UPDATE USER_INFO SET STATE='DE' WHERE STATE='Delaware';
UPDATE USER_INFO SET STATE='DC' WHERE STATE='District of Columbia';
UPDATE USER_INFO SET STATE='FL' WHERE STATE='Florida';
UPDATE USER_INFO SET STATE='GA' WHERE STATE='Georgia';
UPDATE USER_INFO SET STATE='HI' WHERE STATE='Hawaii';
UPDATE USER_INFO SET STATE='ID' WHERE STATE='Idaho';
UPDATE USER_INFO SET STATE='IL' WHERE STATE='Illinois';
UPDATE USER_INFO SET STATE='IN' WHERE STATE='Indiana';
UPDATE USER_INFO SET STATE='IA' WHERE STATE='Iowa';
UPDATE USER_INFO SET STATE='KS' WHERE STATE='Kansas';
UPDATE USER_INFO SET STATE='KY' WHERE STATE='Kentucky';
UPDATE USER_INFO SET STATE='LA' WHERE STATE='Louisiana';
UPDATE USER_INFO SET STATE='ME' WHERE STATE='Maine';
UPDATE USER_INFO SET STATE='MD' WHERE STATE='Maryland';
UPDATE USER_INFO SET STATE='MA' WHERE STATE='Massachusetts';
UPDATE USER_INFO SET STATE='MI' WHERE STATE='Michigan';
UPDATE USER_INFO SET STATE='MN' WHERE STATE='Minnesota';
UPDATE USER_INFO SET STATE='MS' WHERE STATE='Mississippi';
UPDATE USER_INFO SET STATE='MO' WHERE STATE='Missouri';
UPDATE USER_INFO SET STATE='MT' WHERE STATE='Montana';
UPDATE USER_INFO SET STATE='NE' WHERE STATE='Nebraska';
UPDATE USER_INFO SET STATE='NV' WHERE STATE='Nevada';
UPDATE USER_INFO SET STATE='NH' WHERE STATE='New Hampshire';
UPDATE USER_INFO SET STATE='NJ' WHERE STATE='New Jersey';
UPDATE USER_INFO SET STATE='NM' WHERE STATE='New Mexico';
UPDATE USER_INFO SET STATE='NY' WHERE STATE='New York';
UPDATE USER_INFO SET STATE='NC' WHERE STATE='North Carolina';
UPDATE USER_INFO SET STATE='ND' WHERE STATE='North Dakota';
UPDATE USER_INFO SET STATE='OH' WHERE STATE='Ohio';
UPDATE USER_INFO SET STATE='OK' WHERE STATE='Oklahoma';
UPDATE USER_INFO SET STATE='OR' WHERE STATE='Oregon';
UPDATE USER_INFO SET STATE='PA' WHERE STATE='Pennsylvania';
UPDATE USER_INFO SET STATE='RI' WHERE STATE='Rhode Island';
UPDATE USER_INFO SET STATE='SC' WHERE STATE='South Carolina';
UPDATE USER_INFO SET STATE='SD' WHERE STATE='South Dakota';
UPDATE USER_INFO SET STATE='TN' WHERE STATE='Tennessee';
UPDATE USER_INFO SET STATE='TX' WHERE STATE='Texas';
UPDATE USER_INFO SET STATE='UT' WHERE STATE='Utah';
UPDATE USER_INFO SET STATE='VT' WHERE STATE='Vermont';
UPDATE USER_INFO SET STATE='VA' WHERE STATE='Virginia';
UPDATE USER_INFO SET STATE='WA' WHERE STATE='Washington';
UPDATE USER_INFO SET STATE='WV' WHERE STATE='West Virginia';
UPDATE USER_INFO SET STATE='WI' WHERE STATE='Wisconsin';
UPDATE USER_INFO SET STATE='WY' WHERE STATE='Wyoming';