update users set timezone='Europe/London' where uid not in (0);
update field_data_field_location set field_location_value = NULL where field_location_value='select';
update field_revision_field_location set field_location_value = NULL where field_location_value='select';
update field_data_field_profession set field_profession_value = NULL where field_profession_value = 'select';
update field_revision_field_profession set field_profession_value = NULL where field_profession_value = 'select';

##</code><code>##

while(<FILE>){
  $line = $_;
  if ($line =~ m/^update\ (\w*)[^\s]/){
    print $1."\n";
  }
}

##</code><code>##

user
field_data_field_locatio
field_revision_field_locatio
field_data_field_professio
field_revision_field_professio

##</code><code>##

while(<FILE>){
  $line = $_;
  if ($line =~ m/^update\ (\w*)\ [^\s]/){
    print $1."\n";
  }
}

##</code><code>##

users
field_data_field_location
field_revision_field_location
field_data_field_profession
field_revision_field_profession