XF 1.2 How to erase all members current signatures?

[sweetpotato]

My site has a log of signature spam I think I should apply signature permission for new members.
How to erase all new members current signature please?
Thanks,

 

[Jeremy]

Use the batch user management tools.

 

[rdn]

Run this query in your database:

UPDATE xf_user_profile
SET signature = '';

 

[Paul B]

@RoldanLT that is no longer required if running 1.2.

See here: http://xenforo.com/community/threads/user-management-improvements.46217/