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