I want to delete all member signatures...

[Okiewan]

I've set some new rules for signatures (length). Of course no one is paying attention, lol. I'd like to (via query) delete all member's signatures. Help?

[assassingod]

For vB3?
[sql]
UPDATE usertextfield SET signature = ''
[/sql]

[Andreas]

For vB2 (at least 2.2.9, but should be the same for other versions too)

[sql]
UPDATE user SET signature = '';
[/sql]

[Okiewan]

My bad, yes for vB3. Thanks!