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

[Farcaster]

If I understand your goal correctly and you want to update EVERY post in your database to have the same title as the parent thread, then I believe this code will work for you:

[SQL]UPDATE post, thread
SET post.title = thread.title
WHERE post.threadid = thread.threadid
AND post.title <> thread.title[/SQL]

Try it on your test forum first to make sure it works as you expected.