[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