mysql doc表body列存放的html文档,有大量的空白行和字符,需要清洗掉这些无用字符
UPDATE table
SET column = TRIM(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
column,
CHAR(10), ''
),
CHAR(13), ''
),
CHAR(9), ''
),
' ', ''
)
);