I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such as:
Smith, John S.
Doe - Jane W.
Doe John
What I would like to do is to have a script that can update the database
and make all names appear with a comma separating the last and first
name as shown in the first example: Smith, John S.
The rest of the name format does not matter.
Is this possible and if so, can someone be kind enough to help with such
a script and or point me in the right direction.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
