XF 1.2 Query TO Clear About Me For Users With Less Than x Posts

[Brent W]

Cleaning up a spammed forum and want to clear the About Me field for everyone with less than say 30 posts.

 

[Brent W]

Would be nice to ban these users at the same time as well.

 

[Brent W]

Bump. I'll take just a query that clears the About field for users with less than 1 post.

 

[Mike]

UPDATE xf_user_profile AS p
INNER JOIN xf_user AS u ON (u.user_id = p.user_id)
SET p.about = ''
WHERE u.message_count < 1;