[Solved] User name change & quotes

[Stratis]

Hi, I have changed username from one of Smoderators I have, all ok but in all post that have quotes with his posts it shows the old username.

I have run all Maintenance tools & Scheduled Tasks, but old username do not change.

Is there a query to run that can solve this?

Thanks

[Kane@airrifle]

Yes. Usual backup warnings etc.
In phpmyadmin

UPDATE post SET pagetext = REPLACE(pagetext,
'QUOTE=oldusername',
'QUOTE=newusername');