MyBB Community Forums

So,
my hosting provider gave me a warning to remove all the threads,images,posts and sigs that violate their terms and it took me 2 hours to remove all the threads and posts .
Now mainly 80% of the members of my board have obsense/violating the host's terms sigs and I cba to go to everyone's profile to remove the sig one by one .
I wanted to know is their any query / anything I can run which just wipes off the content entered in signature of every member on my board ?

Any help would be appreciated .

In phpMyAdmin (in your mybb database):

UPDATE mybb_users SET signature = '';