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

Adrian Fischer adrian at aussiebidder.com
Sat Sep 28 18:03:02 CDT 2002


Sorry about this.  It is a resend because I lost the info and cant find it
in the archives...


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




More information about the thelist mailing list