How I do I do a global change?

[tsptom]

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.

Thanks!

[Zachery]

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


AdminCP > Maintanence > Update Counters > Update username

[tsptom]

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.