Mass Delete spam posts by username

I have spammers posting junk on my forum and sometimes it takes me awhile before I notice. How do I mass-delete all their posts?

I've been manually searching by the spammer's username in my browser and then deleting the posts one at a time. Very tedious.

I'm on SQL Server, so I could write an SQL query to delete the post from the main entry table, but I'm not sure if there are any dependencies with other tables.

I'm surprised this isn't part of the forum administation. I'm running 7.9

Any recommendations? Is there a plugin to do this? Or does anyone know the exact SQL query to delete from the multiple tables by username?