[thelist] mysql-changing some but not all info in a column
Adrian Fischer
adrian at aussiebidder.com
Mon Sep 9 05:57:01 CDT 2002
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