MyBB Community Forums

I am on myBB 1.6.0

I would like to remove the signatures, homapage link and Bio for all members whose post count = 0.

Can someone help me with the SQL query to accomplish the purpose above?

UPDATE mybb_users SET signature=NULL where postnum=0;
UPDATE mybb_users SET website=NULL where postnum=0;

The bio is part of profile fields. To be honest it sounds like you want to get rid of those spam accounts. Just prune them and delete them.