Bulk change the Attributes in MySQL

Hey everyone...

I have a customer who has manually put in about 300 attributes.. When I am looking over the site, I noticed she must have had the 'Attribute is a Display Only' button checked on all of them. Awesome...

Rather than have her edit all of them over by hand... is there a way I can bulk change them all in PHP MySQL? As well, as remove the 'This Attribute is default' ... I assume i could do it the same way.

I'm not very comfortable with MySQL just yet. and any help would be greatly appreciated.

Thanks so much, in advance...

okay, just figured it out incase anyone needs to know for later.

UPDATE zen_products_attributes SET attributes_display_only=0

worked for me...

Thanks for posting the solution to this ... that is exactly how to fix a global replace on the Attributes when you know the setting you need to update ...

NOTE: Always be sure to backup your database before attempting something like this ...