A script to mass remove a particular character from the top of wordpress posts

I imported a bunch of开发者_开发问答 posts from my old blogger site into wordpress, but every post now has a ">" character at the top of each post. Is there a script I could use to mass remove this character?

---

Run a query on your MySQL database. First take a backup.

update wp_posts set post_content = TRIM(LEADING '>' FROM post_content);

Note if your database table prefix is different, you will need to change the value for wp_posts above.

This also assumes ">" is the very first character.