Magento 1.7 - Mass Short Description Change Through MySQL?

Question

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.

Answer 1

Untested, but you could try something like this:

UPDATE catalog_product_entity_text SET value = 
    REPLACE(value, 'Will_replace_this_text_to_blank', '')
WHERE attribute_id =
    (SELECT attribute_id FROM eav_attribute WHERE attribute_code = "short_description")
    AND EXISTS (SELECT 1 FROM catalog_category_product WHERE catalog_product_entity_text.entity_id = catalog_category_product.product_id AND catalog_category_product.category_id = {CATEGORY ID HERE});