Use UPDATE to fix the states in my_contacts (page 229).
my_contacts
UPDATE my_contacts SET state = RIGHT(location, 2);
mysql>
< Previous PageNext Page >
