XF 2.2 Change a Deleted Persons Name

[JamesBrown]

A deleted user still has their old name. How can I change this? Thanks

 

[Mr Lucky]

For posts you can use this query:

UPDATE `xf_post`
SET `username` = REPLACE(`username`, 'Old', 'New')

For name in quotes I use the post content find replace addon

QUOTES: with Post Content Find Replace addon

Quick Find: Old

Regular expression: /"Old,/i

Replacement String: "New,

 

[and2]

Thanks for the solution @Mr Lucky - however, I wanted to check if there is a solution where I don't have to manually change the whole database?

Any advice from XenForo Officials?

Thanks
Andreas