Query to add "Re: " to threads ((Automatically Quote Post / Thread Title))

[JacquiiDesigns]

Found a thread http://www.vbulletin.com/forum/showt...y+thread+title with a query to remove the "Re: thread title" when automatically quoting post/thread title.... I've actually just enabled the automatic quoting of title. So I wonder if the following query will add the "Re: thread title" to all posts that have no title of their own:

UPDATE post
SET title = 'Re: %'
WHERE title LIKE ''

If no - can someone please advise as to what query I can use to add the "Re: thread title" to all posts?

Thanks so much

Jacquii.

[Marco van Herwaarden]

That will not work i am afraid.

You would first need to get the title of the post you are replying to (if that has a title) and then set that as title of the new post. Not easy.