Need a Query - Delete all avatars in certain usergroup?

[Kopfgeldjaeger]

We are now not allowing avatars for regular members in order to cut down bandwidth a bit.

I have shut off avatar use for regular members but I have a problem:

I cannot figure out how to remove avatars already in use by this usergroup.

There are 23,000 members so removing them by hand is not an option.

Can someone help me by providing a query or another way to remove all of the avatars in use by a certain usergroup please?

Thank you in advance. :confused:

--------------- Added 1194837304 at 1194837304 ---------------

Okay, from another post I figured out how to run the Query, however I get an error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'warrifl_forums.customavatar' doesn't exist

The Query I used is here:

DELETE FROM customavatar WHERE userid IN (2);

With "2" being the Usergroup ID.

Any idea what I am doing wrong?