Hi folks,

I would like to change the username of a member and would like to also change all references to that username with the new username.

That would mean an awful lot of database edits.

I was wondering if there is a 'find and replace' query that I can run to do this?

Thanks

--------------------
Digital Kaos | Dreambox Guides

Possibly create the new username, then merge the old username into the new username (?).

--------------------
OMAC - Supporting Art

Use replacement variables instead from the vBulletin AdminCP -> Style Manager -> Replacement Variables

--------------------
David / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.
Check out my Webmaster Articles at the vBulletin Setup Blog! World of Warcraft Macros

It's easy enough to change the name, just all the references to the name in the posts.

I would like it permanently changed in the database but I'll check out the replacement variables too.

Thanks.

--------------------
Digital Kaos | Dreambox Guides

The replacement variables would be good but the username is part of the url (one of the reasons I want to change it) and the replacement variables changes all the links on the forum too lol.

--------------------
Digital Kaos | Dreambox Guides