List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:August 17 2009 1:13am
Subject:Re: Is there a way ?
View as plain text  
UPDATE table SET col1=REPLACE(col1,'beta.','www.');

Would do what you would need.

On Sun, Aug 16, 2009 at 11:14 AM, m i l e s <magicmiles@stripped> wrote:

> Hi,
> I'm a little rusty in my SQL statements, and I'm not all that certain that
> this can be done.
> IF I have a field with the contents like:
> ""
> where 2 is the record ID value.  And I need to change the contents of that
> field to read:
> ""
> How would I accomplish this with a native SQL statement ?
> I was thinking that I'd just export the contents of the table, and do a
> text manipulation against the field, only to realize that the record id
> value is embedded in the link of the field.  Which means that I can't change
> the record id value at all.  Or turn off the auto increment of the keyfield
> because it will invalidate the records when its turned back on....
> Any suggestions as to how I might clean this up ????
> Thanks.
> Miles
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

Johnny Withers

Is there a way ?m i l e s16 Aug
  • Re: Is there a way ?Johnny Withers17 Aug
  • Re: Is there a way ?Martijn Tonies17 Aug