Getting rid of funny characters

Funny Latin characters got pasted into some of the posts, no this wasn’t an straight forward UTF-8 / Latin encoding issue.
This is how I got rid of them.
update wp_posts
set post_content = replace(post_content,’’’,’\”) ;
update wp_posts
set post_content= replace(post_content,’…’,’…’) ;
update wp_posts
set post_content= replace(post_content,’–’,’-’) ;
update wp_posts
set post_content= replace(post_content,’“’,’”‘) ;
update wp_posts
set post_content= replace(post_content,’”’,’”‘) ;
update wp_posts
set post_content= replace(post_content,’‘’,’\”) ;
update wp_posts
set post_content= [...]