Bulk change the Attributes in MySQL

[pensive612]

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...

[pensive612]

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

UPDATE zen_products_attributes SET attributes_display_only=0

worked for me...

[Ajeh]

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 ...