Pruning users with sql

[John Lester]

I find the default user pruning options to be pretty lame so I want to run a query or two to delete some spammers rather than going through them one by one.

I did some searching but either nobody has done what I want, or I'm waaaay off base on how to do it

Can you use multiple conditions in a query like that? Would you just use AND or is there a more efficient way? An example of what I want to do (and yes it probably isn't right ) is below. I'm not sure if I can use lastvisit (or what value to use) and I guess it's not critical but sure would be better if I could.

DELETE FROM 'users' WHERE 'username' LIKE %! AND 'postcount' =0 AND 'lastvisit' =

I want to delete users with ! in their names, have zero posts, and have not visited in X days.

Is it possible to use more than the ! in the query (ie ! and #)?

--------------- Added [DATE]1340372363[/DATE] at [TIME]1340372363[/TIME] ---------------

Would it be possible to use the condition that they have a url in their homepage?