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'),
  (6, 'text1 \r'),
  (7, 'text1 \r\n')
;

Records: 7  Duplicates: 0  Warnings: 0


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

Rows matched: 0  Changed: 0  Warnings: 0


SELECT * FROM Table1


ID
Product_Name


1
text1

3
text2

4
text3