As I’ve mentioned before, there are only a few select WordPress plugins that should be used by most WordPress blogs. Unless you are running a news site of some sort where your archived posts don’t hold any real value to search engine traffic, you should be using the Related Posts WordPress plugin to try to promote some of your older content.

The first thing you’ll notice after downloading this plugin, is that it is not overly easy to setup up.   In addition to the normal process of uploading it and activating it, you will more than likely need to make an update to one of your databases in order to function.  Here is what the author asks you to do:

ALTER TABLE `wp_posts` ADD FULLTEXT `post_related` (

`post_name` ,   `post_content` )

No idea how to create/alter a table?  No problem.  Here are the steps you’ll need to take to make the adjustment:

1) Backup your databases in case you have a problem.
2) Access your blog’s CPanel.
3) Click MySQL Databases.
4) Scroll down and click PHPMyAdmin.
5) If applicable, select the appropriate database in the menu on the right.
6) Scroll through your databases until you locate wp_posts.
7) In the Structure tab at the bottom, you should see some stuff that looks like this, but without the post_related field:

Post Related

We need to create the post_related field pictured above.

8) Where is says Create an index on 1 columns, click the Go button. You should now see this:

rp index

9) Under index name, type post_related.
10) In the Index type drop-down box, select FULLTEXT.
11) Click Go where it says Add to index 1 column(s).
12) In the first field, select post_date [postdate].
13) In the second field, select post_content [longtext].
14) Click Save.

Now you should see the post_related field pictured above!

Now you just need to tell the plugin where to display your related posts:

<?php if(function_exists('related_posts')) { related_posts(); } ?>

Now that its set up, you can then determine the number of posts you’d like to display from a Options panel under Plugins, and how you’d like to display them.

So, what exactly does this plugin do?  Well, the name of the plugin pretty much sums it up.  Using the keywords in your post titles, this plugin attempts to figure out the most relevant related posts to the post you just wrote, then them wherever you tell the plugin to display the related posts.  This is all done automatically, so you’ve got your plugin setup, there will not be any additional maintenance.

Any questions or thoughts?  Sound off in the comments below!

Kyle Eslick is WordPress enthusiast who took his passion for WordPress to the next level in 2007 by launching as a place to share hacks, tutorials, etc. Follow Kyle on Twitter @KyleEslick!

  1. Roofing San Francisco Contractors says:

    Very interesting site. I have bookmarked you.

  2. milo says:

    There might be an easier way without touching the WP db base:
    – backup all files
    – select a related post plugin (like Bull3t category tagging)
    – cut and paste the pi code in to your theme functions file
    – check if all is in same order like original file
    – save it
    – insert the php call in your single template file

    Voila, you’re done.

  3. VeiBlog says:

    Fabulous site. Keep it up ,best regards and shalom to all of you

  4. ILCRS says:

    Hello. Enjoyed your web site 🙂 ! ! !

  5. Blogward says:

    Great site, keep up the great work

  6. TheIsBlog says:

    good job please keep on the good work

  7. Nicole Kidman 2008 says:

    Thank you for all your emails and help. I have solved my problems with your help and my life is now worth living. I cannot thank you enough for what you have done for me and want the whole world to know how grateful I am for you. Thank you thank you thank you.

  8. Meettelaf says:

    Nice site keep it up

  9. Frances Lui says:

    Thank you for the post. However, I think that your post is not up-to-date because according to the instructions at, we can use the automatic setup found in the tab Plugins->Related Posts Options to create the index table automatically. If the automatic setup fails, then we need to do it manually. I have written an updated post for describing how to install the plugin. Please read it at

  10. Kyle Eslick says:


    You are correct that there is a script, but I have yet to find a person that the script worked for. That is why I went through with adding instructions to do so manually.

    If the script works for you, that is great!

  11. Noakarolina says:

    Very informative. Great site. Really professional.

  12. Very Good! I love it.

  13. Syverailin says:

    Looking for information and found it at this great site. You have an outstanding good and well structured site. I have been looking for sites like this for a long time. Keep up the outstanding work and thank you.

  14. Lokerebecca says:

    Like the site–sorry about the problems with the guestbook though.

  15. Albinhege says:

    Very well done site! Please keep up the good work.

  16. Great site, keep up the great work

  17. I am still thinking of keeping the archives in my side bar but this will definetly help to keep new links going to old site content. I just installed and set it up using the automatic option for this plugin. Thanks for the post. It did help.

  18. TrainTheK9 says:

    I’m afraid this didn’t help at all. Isn’t there a plugin that does this same thing without having to go into cPanel to make this happen?

  19. Thanks for your tips, i use plugin related post now in my blog.

Trackbacks/Pingbacks »

  1. WordPress Theme?Slick Blue | Wordpress Themes says:
  2. Slick Blue WordPress Theme [WP Hacks Themes] says: