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 <magicmi...@gmail.com> 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=joh...@pixelated.net > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net