I am not sure exactly what the issue is (possibly the space?) but this custom user field has issues. I can't update the Title or the description for it from the Admin Console.
With that in mind, I have created a new custom user field with the field id of "firstname"
What I want to do is move all the old data that is under "first name" to now be under "firstname."
Seems simple enough. This data is held in the table xf_user_field_value.
It seems all I need to do is change the field_ids in that table from one to the other. While this seems like a simple SQL replace function, because the field_id is a varbinary, I can't seem to determine what query to run to change one to another. I have run every variation I could find, but there is always a syntax error. This should be pretty simple... but I just can't seem to do it. Any info would help.
For what it is worth:
The value of the old field_id is 6669727374206e616d65
The value of the new field_id is 66697273746e616d65
I am assuming they are so similar because the only difference between the names is a space.