Originally Posted by Gizmo
I'm not saying this will work, since I don't allow HTML posting to attempt to test, but:
WARNING, if you choose to modify your database directly, it is completely unsupported. Please create a backup before executing any query as if something happens this backup is your ONLY resource of recovery.
Code
UPDATE `ubbt_POSTS`
SET `POST_MARKUP_TYPE` = "html"
WHERE `POST_DEFAULT_BODY` LIKE "%</a>%"

Basically it's looking in POST_DEFAULT_BODY for the </a> HTML tag, and if it's found it switches the post type to HTML. You WILL need to run the post content rebuilder.

the only issue I foresee with this, is posts where someone has posted html examples in a code box

I have 840 posts that have have that match that query

"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"