Right from the beginning, I spelled this nice blogging software I use “Wordpress” with a small “p”. The more I searched the internet for blogging-related stuff, I came across the correct spelling “WordPress” with a capital “P”. That was already a long time ago. But as I had also already written a few posts that I didn’t want to change (which I wouldn’t have known how to do at that point, anyway - even if I had wanted to), I continued spelling it in the wrong way - at least, I am pretty persistent when it comes to continuity.

A while ago, I suddenly stumbled across A Plugin to Correctly Spell WordPress. Not Wordpress. Not Word Press that made me change my opinion: yes, right, it is spelled WordPress, not Wordpress.

But instead of installing another plugin (I already have more than enough running), I looked for a way to change the spelling within the WP database - as well in the post title as in the post content.

This site inspired me how to do it via SQL.

For the post title:

UPDATE `wp_posts` SET post_title = replace(post_title,"Wordpress","WordPress");

For the post content:

UPDATE `wp_posts` SET post_content = replace(post_content,"Wordpress","WordPress");

You should be cautious not to overwrite any links. If e.g. you have always spelled it “wordpress” before, then I think that also “wordpress.org” would be affected and changed into “WordPress.org” in the post content - even if it is defined within an HTML link tag. Unfortunately, I do not have a solution for that. As I have always started links with a small “w” and the actual name with a capital “W”, it seems to have worked fine for me!

Now, the only thing for me to do is to remember to spell “WordPress” correctly in each new post. If you still find a wrong spelling, don’t hesitate to contact me.

Beware:
In my first attempt, I got confused and used [...] post_content = replace(post_title [...] - which replaced the content of every post with the post title! So remember to always backup your data first (luckily, I did)!