D6: Update a single db value for all users based on a regex

db update

$result = db_query("SELECT uid FROM {users}");
while ($row = db_fetch_object($result)) {
  $user = user_load($row->uid);
  $new_state_profile = preg_replace('/^(\S){2}\s/', '', $user->profile_state);
  update_sql("UPDATE {profile_values} SET value = '$new_state_profile' WHERE uid = $user->uid AND fid = 6"); 
}

// Clear caches