MySQL Update Statement

UPDATE _vldmembers_data_members
SET data_gender2=3
WHERE data_gender1=1;

UPDATE _vldmembers_data_members
SET data_state=469
WHERE data_city LIKE 'Kansas%';

UPDATE _vldmembers_data_members
SET data_state=457
WHERE data_city LIKE 'colorado%';

UPDATE _vldmembers_data_members
SET data_state=498
WHERE data_city='Houston';

UPDATE _vldmembers_data_members
SET data_state=498
WHERE data_city='Austin'

UPDATE _vldmembers_data_members
SET data_state=461
WHERE data_city='Miami';

UPDATE _vldmembers_data_members
SET data_state=461
WHERE data_city='Tampa';

UPDATE _vldmembers_data_members
SET data_state=456
WHERE data_city='Orange County';

UPDATE _vldmembers_data_members
SET data_state=456
WHERE data_city='Los Angeles';

UPDATE _vldmembers_data_members
SET data_state=456
WHERE data_city='Sacramento';

UPDATE _vldmembers_data_members
SET data_state=456
WHERE data_city='San Diego';

UPDATE _vldmembers_data_members
SET data_state=485
WHERE data_city='New York';

UPDATE _vldmembers_data_members
SET data_state=485
WHERE data_city='New York City';

UPDATE _vldmembers_data_members
SET data_country=210
WHERE data_city='London';

UPDATE _vldmembers_data_members
SET data_country=210
WHERE data_city='nottingham';

UPDATE _vldmembers_data_members
SET data_country=210
WHERE data_city='Birmingham';

UPDATE _vldmembers_data_members
SET data_country=210
WHERE data_city='Brighton';

UPDATE _vldmembers_data_members
SET data_country=210
WHERE data_city LIKE '%yorkshire';

UPDATE _vldmembers_data_members
SET data_state=464
WHERE data_city = 'honolulu';

UPDATE _vldmembers_data_members
SET data_state=468
WHERE data_city LIKE 'Iowa%';

UPDATE _vldmembers_data_members
SET data_state=456
WHERE data_city = 'San Francisco';

UPDATE _vldmembers_data_members
SET data_gender2=3
WHERE data_aboutme LIKE '%lesbian%';