How to remove excerpts and keywords from old posts?

  • 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.

Viewing 7 replies - 1 through 7 (of 7 total)

  • 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=''

    Thread Starter Saqib Islam

    (@saaqi)

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

    Thread Starter Saqib Islam

    (@saaqi)

    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

    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!

    Thread Starter Saqib Islam

    (@saaqi)

    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

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

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

    Thread Starter Saqib Islam

    (@saaqi)

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘How to remove excerpts and keywords from old posts?’ is closed to new replies.