How to run a SQL Query for character in Post Titles

Here is the SQL Query with everything set. This does assume you have the standard wordpress table prefix in your config.

update wp_posts set post_title = replace(post_title,">","")