If you have just imported your posts and comments from Blogger to WordPress then you might have faced two problems:
1. There is a '>' symbol prepended to each post title and post content.
2. Your 'Read more' button from blogger posts is missing.
I have found a simple solution for these problems.
Note: Please take backup of your database before applying above hacks.
1. There is a '>' symbol prepended to each post title and post content.
2. Your 'Read more' button from blogger posts is missing.
I have found a simple solution for these problems.
Removing '>' symbol form WordPress posts
To remove '>' symbol from post titles and content, just run following two queries on you wordpress database:UPDATE wp_posts SET post_title = TRIM(LEADING '>' FROM post_title)
UPDATE wp_posts SET post_content = TRIM(LEADING '>' FROM post_content)
Adding 'Read More' link in WordPress posts
To add 'Read More' link in blogger imported posts you need to run following MySql query on your wordpress database:UPDATE wp_posts SET post_content = REPLACE(post_content, "<a name='more'></a>", '<!--more-->');Blogger identifies the 'Read More' link by "<a name='more'></a>" code snippet. But WordPress does this by finding "<!--more-->". So we have replaced all occurrences of "<a name='more'></a>" with "<!--more-->". Hope this works for you.
UPDATE wp_posts SET post_content = REPLACE(post_content, "<a name="more"'></a>", '<!--more-->');
Note: Please take backup of your database before applying above hacks.