Magento 2 : Delete products having no name using sql or admin

by Neo   Last Updated November 15, 2017 06:09 AM

I uploaded a csv in which there were some products having no name ,so it comes out blank in frontend.
I tried getting these products in catalog_product_entity_varchar but there were no NULL values in this table corresponding to attribute_id of Product Name attribute. Is there any way to delete these products using admin/sql query.

Related Questions

Delete magento attributes?

Updated December 21, 2016 08:03 AM

Deleting products via PHPmyAdmin

Updated December 04, 2017 16:09 PM

Product Delete create re- indexer issue in magento 2

Updated January 04, 2018 11:09 AM