Announcement

Collapse
No announcement yet.

Update thread title

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Update thread title

    I am trying to change a title of a post, I have changed the title in the first post in the 3 pages of posts, but it only changes the first one.. all the other replies show the old title..

    Is there a way to change all the titles in one go?

    Stuart

  • #2
    update thread set title = replace(title, 'oldtitle', 'newtitle')

    or
    update xxxxxx_thread set title = replace(title, 'oldtitle', 'newtitle')

    update post set title = replace(title, 'oldtitle', 'newtitle')

    or
    update xxxxxx_post set title = replace(title, 'oldtitle', 'newtitle')

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X