SEO

#1 (**permalink**) 02-28-2008, 09:49 AM

Is there a way to update just a portion of some data. I have a entry field
for serial numbers, but a new user entered the wrong serial numbers for a
couple hundred serial numbers. She entered AXO-xxxx instead of AX0-xxxx. I
would like to keep the existing numbers, but would like to update the
AXO-xxxx to AX0-xxxx. Thanks for any help you can provide.

A

#2 (**permalink**) 02-28-2008, 09:49 AM

On Mon, 14 May 2007 08:02:29 -0500, "Auddog" <will_k@hotmail.com>
wrote:

>Is there a way to update just a portion of some data. I have a entry field
>for serial numbers, but a new user entered the wrong serial numbers for a
>couple hundred serial numbers. She entered AXO-xxxx instead of AX0-xxxx. I
>would like to keep the existing numbers, but would like to update the
>AXO-xxxx to AX0-xxxx. Thanks for any help you can provide.
>
>A
>

Something like :

UPDATE table
SET serial=CONCAT('AX0-',SUBSTRING(serial,5))
WHERE serial LIKE 'AXO-%';

#3 (**permalink**) 02-28-2008, 09:49 AM

I will give that a try - thanks for the help/

A

"subtenante" <zzsubtenantezz@gmail.com> wrote in message
news:0nng43l5foson5o6te52ilclc4r6q9p8bd@4ax.com...
> On Mon, 14 May 2007 08:02:29 -0500, "Auddog" <will_k@hotmail.com>
> wrote:
>
>>Is there a way to update just a portion of some data. I have a entry
>>field
>>for serial numbers, but a new user entered the wrong serial numbers for a
>>couple hundred serial numbers. She entered AXO-xxxx instead of AX0-xxxx.
>>I
>>would like to keep the existing numbers, but would like to update the
>>AXO-xxxx to AX0-xxxx. Thanks for any help you can provide.
>>
>>A
>>
>
> Something like :
>
> UPDATE table
> SET serial=CONCAT('AX0-',SUBSTRING(serial,5))
> WHERE serial LIKE 'AXO-%';

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

updating records