#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    1
    Rep Power
    0

    Removing links from posts in wordpress


    Hi to all,
    I am not very good with mysql so i need some help.
    I am trying to remove some specific links from my wordpress blog. I have a lot of outgoing links to several domains and i want to remove just links to one of them. For example all links that lead to dontneedlink.com or start with dontneedlink.com/(some child page)

    I already try

    UPDATE wp_posts SET post_content = REPLACE (
    post_content,
    'Item to replace here',
    Replacement text here');

    But this is not god for me because I have a lot of key words and there is a lot of combinations.

    So I need some kind of query to recognize my links that include dontneedlink.com and to remove href text and leave keyword untouched.

    <a href=”http:// dontneedlink.com”>Test</a> -> Test
    <a href=”http:// dontneedlink.com”>Test Again</a> -> Test Again
    <a href=”http:// dontneedlink.com/childpage”>Test Again 2</a> -> Test Again 2

    Is this possible at all?
    This would save me a lot of time instead to go from one to another post and remove manually.

    Thanks in advance!
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,150
    Rep Power
    4274
    Originally Posted by miller55
    Is this possible at all?
    no, not really

    you would have to hardcode each specific link to be changed into the sql somehow
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo