Monthly Archives: April 2010

Remove greater than symbol from beginning of imported blogger titles and posts in wordpress

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.