Mass Delete Spammers Based on IP

[q8mazad]

Hello

I found that there are thousands of unwanted posts / spammers members and they all have the same IP address

How do i mass delete members/post based on an IP address?

through the SQL query , I was able to get the userid , username through this line

select userid,username from post where ipaddress='x.x.x.x';