I have a problem with a large quantity of my products on my catalog list having the same short description. About 11 thousand items, this will take forever to change individually. I did some research and it seems that I can change these through a php script or through MySQL syntax. However, there is no identifying attributes for these specific 11 thousand items to separate them from the other few thousand items. They are however in their own Category. Can I do a database query and select all items in a specific product category and than replace the short description with something like this
(I found this code in a previous post with a similar problem)
UPDATE catalog_product_entity_text SET value = REPLACE(value, 'Will_replace_this_text_to_blank', '')
That being said, could someone lay out some step by steps to help a newbie out.