[Rik Brown]

Can anyone advise some mysql queries to loop through the title of each thread in the thread table and, if the thread's corresponding posts in the post table have a different title, to update the post title to match the thread title?

Basically, I cannot understand how to loop through a table (have been Googling many pages on the matter). I'm assuming one would make a join on the two tables and then simply loop row-by-row based on thread title.

For testing/viewing purposes on one forum, I've made the following query:

SELECT thread.threadid, thread.title, post.postid, post.title
FROM thread
JOIN post
WHERE post.threadid = thread.threadid
AND thread.forumid IN (174) 
AND thread.title != post.title
ORDER BY thread.threadid, post.postid
LIMIT 30

This finds the post titles that no longer match their corresponding thread titles. It appears all I would need to do now is loop through the table row-by-row and "update" the post title to match the thread title.

Does anyone know how to accomplish this using mysql?

Thanks. -- Rik