update hw2_user set state='NY' where state=' NY';
update hw2_user set state='NY' where state='New York';
update hw2_user set state='NY' where state='NY - New York';
update hw2_user set state='MA' where state='Massachusetts';
update hw2_user set state='AL' where state='Alabama';
update hw2_user set state='MD' where state='MD Maryland';
update hw2_user set state='PA' where state='PENNSYLVANIA';
update hw2_user set state='NC' where state='North Carolina';
update hw2_user set state='OH' where state='Ohio';
update hw2_user set state='TX' where state='Texas';
update hw2_user set state='CA' where state='California';
update hw2_user set state='MD' where state='Maryland';
update hw2_user set state='FL' where state='Florida';
update hw2_user set state='Fl' where state='Fl';
update hw2_user set state='MA' where state='ma';