您可以首先消除重复项，然后更新其余项

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

fiddle
万一你也有cr lf或cr单独

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

fiddle