SELECT REPLACE(field_1, char(10), '') as '去除换行符' FROM my_table;
SELECT REPLACE(field_1, char(9), '') as '去除水平制表符' FROM my_table;
SELECT REPLACE(field_1, char(13), '') as '去除回车符' FROM my_table;
使用REPLACE和CHAR
SELECT REPLACE(field_1, char(10), '') as '去除换行符' FROM my_table;
SELECT REPLACE(field_1, char(9), '') as '去除水平制表符' FROM my_table;
SELECT REPLACE(field_1, char(13), '') as '去除回车符' FROM my_table;
使用REPLACE和CHAR