DELETE FROM chemhost.product_package pkg

WHERE pkg.brand = 'ep'
AND cat_no IN (

SELECT
DISTINCT cat_no
FROM chemhost.product_package tmp_pkg
WHERE tmp_pkg.brand = 'ep'
AND tmp_pkg.PACKAGE LIKE '%*%'
)
AND pkg.PACKAGE NOT LIKE '%*%'