From: Keith Ivey (keithsmokefreedc.org)
Date: Fri Mar 25 2005 - 11:03:26 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

zzapper wrote:

> ONE1 -> ONE0001
> ABC23 -> ABC0023
> FGH123 -> FGH0123
>
> What Update Query should/could I have used?

Something like this perhaps?

UPDATE table_name SET propertyID = CONCAT(LEFT(propertyID, 3),
LPAD(SUBSTRING(propertyID, 4), 4, '0'))
WHERE propertyID REGEXP '^[A-Z]{3}[0-9]{1,3}$';

--
Keith Ivey <keithsmokefreedc.org>
Smokefree DC
http://www.smokefreedc.org
Washington, DC

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]