On Fri, 25 Mar 2005 12:03:26 -0500, wrote:
>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,
Thanx that works just fine
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
