I remembered last time after I upgraded WordPress, some of my blog entries have weird characters as per below picture. Then I have take few minutes to edit some post entries in order to amend these weird characters, unfortunately I get bored and lazy to do so, then I just let it be.

Now I only know there are few methods which can help you to replace these weird characters very easily. Anyway, before you going to do anything, remember to backup your database first to avoid data lose.

Method 1: Use Search and Replace WordPress Plugin

This plugin allows you to search and replace texts across all your posts. As usual, download the plugin, install and active it and then you are ready to go.

Method 2: Using PhpMyAdmin under Your Hosting Control Panel

You have to login to your hosting control panel and click on PhpMyAdmin to proceed. If you are not so familiar how PhpMyAdmin works, be sure you back up the database first.

1. Open your database in PhpMyAdmin
2. Click on the SQL tab and use the following quote and paste to the text area

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

3. Click “Go” button