You use a update query like
https://www.ubbcentral.com/forums/u...your-forum-from-http-to-https#Post260501But you would do it for the path and not just https.
Remember there are two fields in ubbt_POSTS
POST BODY and POST BODY Default
Also there is no UNDO
So when you specify what to change grab a chunk of the path
like
https://www.ubbcentral.com/forums to say
https://www.ubbcentral.com/ubb/forumsnot just something that could be part of another word or something you want unique to change
All in all it is very quick
I first created all the query's in notepad then copy paste to mysql
It runs very quick