mySQL - rename Post `title` to match Thread `title`

[Rik Brown]

Originally Posted by Marco van Herwaarden

Instead of duplicating the thread title to all posts, it might have been better to remove the title for these posts.

Marco:

I can't imagine any advantage to having no post title in contrast to having the correct post title. We are simply making sure that the thread title we either fix or enhance (for Google purposes, etc.) is likewise applied across the thread instead of having post titles like "Newbie Question."

Regards. -- Rik

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

As I mentioned above, I decided to spread the query forum-by-forum so it doesn't attempt to do everything at once and bring the server to its knees. Here is the code for a mysql STORED PROCEDURE that I'm currently using:

BEGIN
	DECLARE count INT default 0;
	SET count = 1;

	WHILE count <= 550 DO
		UPDATE post, thread SET post.title = thread.title WHERE post.threadid = thread.threadid AND post.title <> thread.title AND thread.forumid = count;
		SET count = count + 1;
	END WHILE;
END

We only have a little over 100 forums but they are spread over forumids 1-514 at the moment. The above simple procedure bypasses forumids that do not exist and runs the one line query only on each forum that does exist.

I'm sure this could be improved with more coding (please feel free to advise) but it does what I need without knowing much about writing stored procedures.

I hope that this helps someone else.

Regards. -- Rik