[thelist] mysql-changing some but not all info in a column

[r937 at interlog.com]

> http:/domain.com/images/nicepic.gif
>
> becomes
>
> http://newdomain.com.au/blah/blah

hi adrian

assuming you wanted to leave the path and file name alone,

  update yourtable
     set thecolumn
        = replace(thecolumn,'domain.com','newdomain.com.au')

rudy