I was wondering if someone knew how to fix this.
On our site we have about 300 categories in total. One of the link property we have for all listings is link_type (ENUM) and options for this are blue, green, yellow & white. Now all the listings are having blue as default, as this link property was added recently.
However within 19 specific categories (1 root category and are its 18 sub categories) all the links should be having ENUM field link_type to be set to 'white'. I also have category ID for root category and each of its sub categories.
It would be very much appreciated if someone can tell me on how to edit link_type (ENUM) values of all the listings within these categories all at once instead of having to edit each listing in there individually.
Thank you for the help.
Vishal
-------------------------------------------------------
On our site we have about 300 categories in total. One of the link property we have for all listings is link_type (ENUM) and options for this are blue, green, yellow & white. Now all the listings are having blue as default, as this link property was added recently.
However within 19 specific categories (1 root category and are its 18 sub categories) all the links should be having ENUM field link_type to be set to 'white'. I also have category ID for root category and each of its sub categories.
It would be very much appreciated if someone can tell me on how to edit link_type (ENUM) values of all the listings within these categories all at once instead of having to edit each listing in there individually.
Thank you for the help.
Vishal
-------------------------------------------------------
Link Properties MySQL Query Help