Query to split thread by post date

[Newtonhead1]

Greetings everyone,

I manage several mid sized forums with established threads that need to be regularly split to keep them to manageable size. Manually selecting hundreds of posts to be move is a time consuming job, so I'm looking to speed up the process.

I would sincerely appreciate if someone could provide a mysql query that would allow me to move posts from one thread to another by post date range.

In other words, I would like to run a query wherein I would enter the source and target thread id's and a start and end date range for the posts to be moved.

FYI, In case it makes a difference, I'm currently in vb 3.0.6, although I'm planning the upgrade to the latest version as soon as we finish documenting all of our telpmate mods.

Thanks,

Newtonhead1