vBulletin Change Thread Prefixes For All Threads In Forum

[Kevin]

Recently I had the need to add a new prefix to an existing vBulletin forum that had hundreds of threads. Manually editing each thread to change the prefix was not an ideal solution.

This query will take care of that for you. Replace {prefixID} with the Prefix ID you created and {999} with the forum ID that you want to bulk update.

update thread set prefixid = '{prefixID}' where forumid='{999}';