all over my forum, there are posts with various images on my server. all of them are at the same url, like this:<br /><br />http://www.robkamphausen.com/image/place/image1.jpg<br />http://www.robkamphausen.com/image/place/image2.jpg<br />http://www.robkamphausen.com/image/place/image3.jpg<br /><br />if i wanted to move all of those images, is there any command i can enter that will automatically change the url of the posts? like, something that will universally change all references of:<br />http://www.robkamphausen.com/image/place/<br /><br />to:<br />http://www.robkamphausen.com/image/place/boards/<br /><br />?

Is the URL of the images in the content of the posts itself?

UPDATE w3t_Posts SET B_Body = REPLACE(B_Body, 'robkamphausen.com/image/place/','robkamphausen.com/image/place/boards/');

[]Medar said: <br />Is the URL of the images in the content of the posts itself? [/] <br /> <br />naw, its not the actual URL. its a posted image, so it'll look like this: <br /> <br />

[]Anno said:<br />UPDATE w3t_Posts SET B_Body = REPLACE(B_Body, 'robkamphausen.com/image/place/','robkamphausen.com/image/place/boards/'); [/]<br /><br />so this'll actually change the image URL? (NOT just a hyper link?)

What Anno said <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />That will change every instance in your B_Body (Post Content field) of:<br /><br />robkamphausen.com/image/place/<br /><br />Into:<br /><br />robkamphausen.com/image/place/boards/<br /><br />Test a single post first, make sure it is what you are wanting to do. Add a:<br /><br />WHERE B_Number=xxxxx;<br /><br />on the end to test a single post.

awesome!<br /><br />i'll play around with this tonight -- that should definitely help me organize stuff on my server a lot more efficiently.<br /><br />thanks guys!

>Test a single post first, make sure it is what you are wanting to do.<br />Ah, yes, good advice.<br />And for an additional measure, make sure you have a recent database backup.

btw, i've used this a few times and it works GREAT!!!<br /><br />thanks <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />