For some strange reason whenever I import blogger posts into wordpress a greater than symbol is added at the front of each post title and main text. I looked into the wordpress mySQL database and found that in the table wp_posts the columbs post_title and post_content had the error.
So I spent a while and eventually came up with two queries that removes all greater than arrows from the begining of each post and title:
UPDATE wp_posts SET post_title = TRIM(LEADING '>' FROM post_title)
UPDATE wp_posts SET post_content = TRIM(LEADING '>' FROM post_content)
And now that clears up my problem, although it would be nice to automate this.
I hope this is helpfull to someone.
Great!
Worked like charm !!! Thanks.
Thank you soooo much. This was very helpful for me. Worked superbly.
Thank you very much!!
I’ve read all kind of solutions for this problem, but this is the easiest. 🙂
Btw, i also had the “greater than” symbol at more than 3000 imported comments, so i ran this query too:
UPDATE wp_comments SET comment_content = TRIM(LEADING ‘>’ FROM comment_content)
Thank you again, Jonathan!