How I do I do a global change?

  • Time
  • Show
Clear All
new posts
  • tsptom
    Senior Member
    • Feb 2014
    • 264
    • 4.2.X

    How I do I do a global change?

    How do I do a global change in mysql (despite the strangely worded title )?

    If a user changes his username (and I know this is rare) how would I do some sort of global change in the database to change all references to the username, including text within posts and "Originally Posted by" xxxxx, to the new name?

    I know how to do that in unix, but not mysql.

    Last edited by tsptom; Sun 13 Jul '08, 12:59pm.
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    You'd run the update username change after changing their name in the admincp.

    AdminCP > Maintanence > Update Counters > Update username


    • tsptom
      Senior Member
      • Feb 2014
      • 264
      • 4.2.X

      I see what you are doing there, and that would work for what I described, but what actually happened was that the member created a new name, and for personal reasons, wanted to delete his old identity (including posts and references to him) completely.

      So, I deleted the old account along with all of his posts, and now I want to globally change any refernce to his old username in any post (text), so that no one can search on his name and find something written by him, or about him.

      I hope that makes sense. Thanks again.


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