Username of deleted user still shows in thread starters
 

Hello,

Recently I deleted a user's profile, and the posts, but kept the threads the user had started.

Now the threads show up with the username and then "Guest" below it. I realise I need to remove the username manually from the posts in the database, since the user profile is gone, so how do I go about doing that?