WordPress.org

Ready to get started?Download WordPress

Forums

How to remove excerpts and keywords from old posts? (8 posts)

  1. Saqib
    Member
    Posted 2 years ago #

    Hi fellows,

    My name is Saqib Islam, I am using wordpress for 3 years now. I have made around 700 posts in my blog. I use All In one Seo plugin for SEO purposes.

    Now I have used wordpress original excerpt option to make descriptions and All in one seo keywords area for keywords.

    Now I want to drop all the keywords that I have added to the posts as well as excerpt from my blog.

    Is there any way that I can do these things automatically or do I have to edit each and every single post manually.

    Thank you for all your support and help.

  2. adpawl
    Member
    Posted 2 years ago #

    To delete keywords, you can use sql query:
    DELETE * FROM wp_postmeta WHERE meta_key='_aioseop_keywords';

    To delete all wp excerpts, yuo can use:
    UPDATE wp_posts SET post_excerpt=''

  3. Saqib
    Member
    Posted 2 years ago #

    Ok great thank you very much sir @adpawl I'll try it

  4. Saqib
    Member
    Posted 2 years ago #

    Hello Sir I don't under stand how that works. I have tried both commands in myphpadmin but error comes up

    "You have to choose at least one column to display"

    I have chosen column too but some other kind of error pops up.

    Please can you give me some Idea how to use these commands

  5. adpawl
    Member
    Posted 2 years ago #

    On left column - select your WP database.
    On right - put this query in SQL tab.

    If your prefix is different than wp_, correct it in queries!

  6. Saqib
    Member
    Posted 2 years ago #

    I have tried that but this error pops up

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM 7274_postmeta WHERE meta_key='_aioseop_keywords'' at line 1

    Here I am putting a screen shot please check

    http://i46.tinypic.com/334q100.jpg

  7. adpawl
    Member
    Posted 2 years ago #

    Try: DELETE FROM 7274_postmeta WHERE meta_key='_aioseop_keywords';

  8. Saqib
    Member
    Posted 2 years ago #

    Okay that worked flawlessly. Thank you very very much sir.

Topic Closed

This topic has been closed to new replies.

About this Topic