SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('column_a','column_b')
AND TABLE_SCHEMA='the_database_to_look_in';
Magento 1 Categories, with and without Flat Tables
Sometimes Magento leaves you wondering, “WHY!?!?!?!?!?”
If flat categories are enabled, and you want all the children of a parent category, do this:
$children = Mage::getModel('catalog/category')->load($theCategoryIdHere)->getChildrenCategories();
If they are not enabled, do this:
$children = Mage::getModel('catalog/category')->getCategories($theCategoryIdHere);
How do you know if they are enabled?
if (Mage::helper('catalog/category_flat')->isEnabled()) {}
Also, getChildrenCategories() on the flat category list returns the category objects in the same order you find them in the admin category manager. However,
Mage::getModel('catalog/category')->load($theCategoryIdHere)->getChildren();
returns a comma separated string of child category ids in numerical order.