It depends on the configuration. Check from eav_attribute table the attributes.

  • 41 category name
  • 71 name of product
  • 72 description
  • 73 short description
  • 84 meta_description
  • 96 status
  • 97 url_key

Beware there is a type_id associated with certain attribute_id

select entity_id, value from catalog_product_entity_text where attribute_id = 73 and value like ‘%MF1%’

update catalog_product_entity_text set value = replace(value,’MF1′,”) where attribute_id = 73 and value like ‘%MF1%’ and entity_id = 1705

Leave a Reply