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

Greetings all,

I have a mysql db and in one of the columns I have a url to an image.  I
need to change the domain part of the url.  The rest remains the same.

so...

http:/domain.com/images/nicepic.gif

becomes

http://newdomain.com.au/blah/blah

There is about 700 records to change.  Time consuming if I have to do it by
hand to say the least.

Any Ideas would be appreciated

Regards

Adrian Fischer