MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table1
    (`ID` int, `Product_Name` varchar(8))
;
    
INSERT INTO Table1
    (`ID`, `Product_Name`)
VALUES
    (1, 'text1'),
    (2, 'text1 \n'),
    (3, 'text2'),
    (4, 'text3'),
    (5, 'text4 \n')
;

Records: 5  Duplicates: 0  Warnings: 0


DELETE FROM Table1
WHERE `Product_Name` LIKE '%\n'
AND EXISTS ( SELECT 1 FROM (SELECT * FROM Table1) t2 
  WHERE t2.`Product_Name` = TRIM(REPLACE(Table1.`Product_Name`,'\n','')));

UPDATE Table1 SET `Product_Name` = TRIM(REPLACE(`Product_Name`,'\n','')) WHERE `Product_Name` LIKE '%\n'

Rows matched: 1  Changed: 1  Warnings: 0


SELECT * FROM Table1


ID
Product_Name


1
text1

3
text2

4
text3

5
text4