SELECT `id`,`ProductPhoto`,`ProductName`,`pdate` FROM newproduct t1 WHERE EXISTS (SELECT 1 FROM newproduct t2 WHERE t2.`ProductName` = t1.`ProductName` GROUP BY t2.`ProductName` HAVING COUNT(t2.`ProductName`)=1 );
SELECT `id`,`ProductPhoto`,`ProductName`,`pdate` FROM newproduct a inner join (select `ProductName` FROM newproduct group by `ProductName` having count(*)=1) b on a.`ProductName`=b.`ProductName`
FROM newproduct t1
WHERE EXISTS (SELECT 1 FROM newproduct t2
WHERE t2.`ProductName` = t1.`ProductName`
GROUP BY t2.`ProductName`
HAVING COUNT(t2.`ProductName`)=1 );
(select `ProductName` FROM newproduct group by `ProductName` having count(*)=1) b
on a.`ProductName`=b.`ProductName`