how to enable disabled products via query?

Question

Hi I want to enable all products I have in my Magento 2 store, is there any query to enable all products we have using a single sql query ?
Thanks

Answer 1

below sql command useful for you

SELECT entity_id FROM `catalog_product_entity_int`
    WHERE attribute_id = (
        SELECT attribute_id FROM `eav_attribute`
        WHERE `attribute_code` LIKE 'status'
    ) AND `catalog_product_entity_int`.value = 1