I am not certain which group to post this to - sorry if this is the wrong
I have a table that holds the location of various media and such (mostly
images). One field is the Media name, the other is the URL in the form
http://myServer.gunnery.org/media/pic1 for example. we are about to move
all the media to a new location (new server). the paths will remain the
same except for the server name.
Is there an update statement that will let me go through the table an
replace myServer with newServer in all the URLs (and leave the ...