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
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Mark [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 25, 2006 1:18 PM
To: mysql@lists.mysql.com
Subject: Remove unwanted characters from a name field
I have a field called name which stores a person's first, middle and
last name
Mark wrote:
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 -
On 10/25/06, Mark [EMAIL PROTECTED] wrote:
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