Thanks for the quick reply,
So to clarify, this can't be done in just one query? Just checking to verify the limits of the update queries.
As far as the temporary table....that is the next think I will need to learn how to do.
as of now, I am simply doing a dump, make changes, check, leave as is or restore as needed.
At some point I would like to write a script in php that I will be able to
One select 2 names and player IDs
Generate a "count" summary of each ID.
Then merge the 2 ID's into 1.
But I am still fairly new and have a ways to go (like becoming proficient with MySql and learnign html and php from scratch) before talking that.