Turn off REQUIRED in attributes

[tootie_rutz]

I have an attribute option that is set to TEXT. I have all products using this and it's set to REQUIRED. I need to turn it OFF. Is there a way to do a MASS TURN OFF with a click of a button?

[Ajeh]

Do you want this turned off for *every single attribute that you have*?

[tootie_rutz]

YES, exactly
!

[Ajeh]

Just post on this the other day ... now what was that handy dandy SQL statement ...

Oh yeah ...

BACKUP your database first ...

Did you back it up?

This will remove all of the require settings:

UPDATE products_attributes SET attributes_required = 0;