List out all the product names in Magento via SQL code

You know we can easily fetch the product names using the Model object. But what if you want to list out all the product names via SQL code? Don’t worry here is the SQL code for you: SELECT `value` AS product_name FROM catalog_product_entity_varchar WHERE entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = ‘catalog_product’) AND …

Read more