Hey happy birfday!
It thought this could be done with prune or move in the control panel. But no.
So I guess the logical process would be to look at user posts via the profile method and edit them one at a time.
I would be leery of just editing the database since it impacts several tables when a user posts a topic or reply.