|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
"Repairing Data" packing with zeros
From: zzapper (david
tvis.co.uk)
Date: Fri Mar 25 2005 - 04:54:06 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi,
I needed to repair some data that had been entered inconsistently, I was in a rush so I did it
manually via SqlYOG. (too much of a rush to consider how to do it quickly!)
The bad data in one column propertyID
was of kind
\w\w\w\d eg ONE1
\w\w\w\d\d eg ABC23
\w\w\w\d\d\d eg FGH123
when they all needed to packed with zeros as necessary
\w\w\w\d\d\d\d
so
ONE1 -> ONE0001
ABC23 -> ABC0023
FGH123 -> FGH0123
What Update Query should/could I have used?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]