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
