MySQL查询时候自动去除回车和空格

MySQL查询时候自动去除回车和空格

SELECT
    REPLACE (customerno, '\n', ''),
    freight,
    transremark,
    REPLACE (special, '\n', ''),
    REPLACE (remark, '\n', '')
FROM
    yd
WHERE
    customerno LIKE '%YS202304030004%'