Skip to content

Instantly share code, notes, and snippets.

@ryaan-anthony

ryaan-anthony/gist:6513155

Created September 10, 2013 18:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ryaan-anthony/6513155 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ryaan-anthony/6513155 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
UPDATE `catalog_category_entity_int` `e`
LEFT JOIN `eav_attribute` `a`
ON `a`.`attribute_id` = `e`.`attribute_id`
SET `e`.`value` = 1
WHERE `a`.`attribute_code` = 'is_anchor'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment