有些用户的留言全是空格、回车换行、tab之类的东西,要去掉它们
UPDATE
t1
SET
txt = REPLACE(
REPLACE(
REPLACE(
REPLACE(txt, CHAR(34), ''),
CHAR(13),
''
),
CHAR(10),
''
),
CHAR(9),
''
) "; 有些用户的留言全是空格、回车换行、tab之类的东西,要去掉它们
UPDATE
t1
SET
txt = REPLACE(
REPLACE(
REPLACE(
REPLACE(txt, CHAR(34), ''),
CHAR(13),
''
),
CHAR(10),
''
),
CHAR(9),
''
) ";