Originally Posted by roly

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