Phpmyadmin - post editing

Question

i am total newbie with phpmyadmin, and the first time i use it, was to delete a lot of spam comments.I m not sure is it possible to do what i want , but another option would be to go trough 400-500 articles and do it manually.

ok, what i need with phymyadmin is this.When i started my blog it was with blogger.com which was limited.Two years ago i switched to wordpress,and imported all those posts.Since it was limited i add a lot of links pointing to some other area of blog.

So is its possible to delete for an exmaple all those links from posts without deleting the posts.I want to keep them, and only delete for example some link which they contain.

Trough phpmyadmin search i found all those links and posts, now the only thing i need is to delete automatically this links. I m hoping i explained this well.

Answer 1

Mysql allows you to run queries that apply to all post, see example :

UPDATE wp_posts SET POST_CONTENT = replace(POST_CONTENT, '<a href="http://mysite.com/my_link">mylink</a>', '');

This code allows you to delete <a href="http://mysite.com/my_link">mylink</a>on all posts. But in your case I doubt all links are the same so you need a pattern. Perhaps it can be done with [REGEXP].1

Do you need to delete all links in content? That would be easier.

EDIT: make a backup of your database before anything !