I need a mysql query that will mass change the forum id of threads. I want all threads in forum id 111 to be changed to have the forum id of 129. I have several thousand (over 100,000) threads that need to be moved, thanks. As long as it can execute in phpmyadmin this is what I'm looking for.
I need a custom mysql query please
Collapse
X
-
Tags: None -
reread, post again. Thank you.Comment
-
I'm not sure if that got it or not.
SQL Output
1 lines in 37.715 sec. parsed.
Executed 0 DROP-, 0 CREATE-, 0 INSERT-, 1 UPDATE-Commands
It had 0 Comments
0001: UPDATE `thread` SET forumid=129 WHERE forumid=111;
no records
It seems to have done the trick, thank you.Comment
-
Comment
-
Loco thread is done and over with. I tried via the admincp and with my shared host it didn't work. You don't know what setup I have and you don't know the results of what I tried either. When I request stuff like this, I do it for a reason.Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment