Q: SQLSTATE[HY000]: General error: 1442 Can't update table 'catalog_product_entity_varchar' in stored function/trigger I am running a MySql Trigger, and want to update the value of the attribute 260, I got this error:

SQLSTATE[HY000]: General error: 1442 Can't update table 'catalog_product_entity_varchar' in stored function/trigger because it is already used by statement which invoked this stored function/trigger., query was: UPDATE catalog_product_entity_varchar SET value = ? WHERE (entity_id = 6779) AND (attribute_id = '260') AND (store_id = '0')

From the code:
CREATE TRIGGER change_network_ebay BEFORE UPDATE ON catalog_product_entity_varchar
FOR EACH ROW
BEGIN 
IF NEW.attribute_id = '260' THEN  
   UPDATE catalog_product_entity_varchar 
   SET NEW.value = '4G/LTE' where entity_id = NEW.entity_id AND NEW.attribute_id= 260 ;
END IF;
END;  

And this is how my database looks like:


How can I fix the problem?
