MyBB Community Forums

I converted my SMF forum over to mybb, I can deal with majority of the conversion problems manually with my forum staff, but a lot of topics have this symbol, "Â" in it just randomly. It looks like this:

http://puu.sh/6WfFI.png


Is there a way to mass remove that symbol from all posts? Maybe an SQL query I can submit. Help is much appreciated, thank you.

---

I figured out how to do it. I just ran this query:

update mybb_posts set message = REPLACE(message,'Â','')

This post can be closed now, thank you.