XF 1.5 Deleted member name change

[upnet]

A member asked that their profile be deleted so I used the ACP member delete function. This turns the member into a guest but their name remains. Is there any way to alter their name at this point? A query to the database perhaps?

 

[Jake Bunce]

UPDATE xf_thread
SET username = 'newname'
WHERE user_id = 0
AND username = 'oldname'

UPDATE xf_post
SET username = 'newname'
WHERE user_id = 0
AND username = 'oldname'

 

[upnet]

UPDATE xf_thread
SET username = 'newname'
WHERE user_id = 0
AND username = 'oldname'

UPDATE xf_post
SET username = 'newname'
WHERE user_id = 0
AND username = 'oldname'

Perfect thanks.