> Sorted!! I simply did the SELECT REPLACE () AS newContent then an UPDATE > query using the newContent. Loop through the contentid from 1 to 80 on an > index loop. > Cool.... Sorry I didn't get back to you - had to head out the office for a while...
You probably could have done an REPLACE ..... SELECT....... http://www.mysql.com/doc/en/REPLACE.html or probably just an UPDATE would have done it so it was all in SQL.... > All links changed in about 12.5 secs. Certainly beats finding and editing > manually!! > Aye definately!! You always miss some when you have to go through by hand... :o\ Regards Stephen =============================== CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
