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:
>
> "http://beta.somedomain.com/url/url/url=2"
>
> where 2 is the record ID value.  And I need to change the contents of that
> field to read:
>
> "http://www.somedomain.com/url/url/url=2"
>
> 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: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
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