SQL query to assign threads a prefix

[kgroneman]

I'm needing to assign all threads in a specific forum that do not currently have a prefix to an existing prefix. Is there some kind soul out there that could show me an SQL query that would do such a thing? I sure would appreciate it. Thanks in advance.

[Inna]

First, in "prefix" table of vBulletin find your desired "prefixid" (it could be an alphabetic name or numerical one). In my case, it's id is "test".
Now run this query in "thread" table:

UPDATE `thread` SET `prefixid` = 'test' WHERE `forumid` = 1;

Where forumid is the id of your desired forum.
Before running any query, please make a backup of your thread table.

[kgroneman]

Thanks! much appreciated. This looks like it may set ALL threads to that prefix instead of just threads without a prefix, but what do I know. :-) I'll test it out before using it in a critical forum and report back.

--------------- Added [DATE]1517934535[/DATE] at [TIME]1517934535[/TIME] ---------------

This worked with a slight modification to achive my desired results:

UPDATE vb_thread SET prefixid = '1' WHERE forumid = 10 and prefixid <> '3' and prefixid <> '2'

All good now. Thanks.

[Inna]

You can use AND query

UPDATE `thread` SET `prefixid` = 'test' WHERE `forumid` = 1 AND 'prefixid' =''

--------------- Added [DATE]1517935538[/DATE] at [TIME]1517935538[/TIME] ---------------

My appreciation my friend