hi
just a quick question. i need to modify part of a url in lots of posts in some wordpress blogs. the table and field is wp_posts post_content so if some of these posts contain the url
http://www.somesite.com/folder and i want to change it to
http://www.anothersite.com/folder does anyone know what sql i should use in phpmyadmin to make this change on all the posts?
there's obviously other text in the posts to be changed that i want left alone its just a particular url i want to change.
any help appreciated, thanks in advance