We are running MySQL as the backend for a document management system. Unfortunately, things were well underway before I arrived on the scene. Now, we have have about 44,000 records in the DB that need to be fixed. The problem is that all names were entered FIRST LAST instead of LAST, FIRST.
I've read the other posts that talk of how to select the last name, but I don't want it merely selected or even split into a second column. I need the last name, re-inserted into the field and formated LAST, FIRST.
Also, I want to work on a backup table instead of the actual data. Once I succeed in reversing the two names, can I simply rename the new table to replace the old one? I want to ensure there's no unique identifier that I risk screwing up that way.
Your help would be greatly appreciated.