update phome_ecms_news set smalltext = REPLACE(smalltext ,' ','') ;
/*清楚空格*/
UPDATE phome_ecms_news SET smalltext = REPLACE(REPLACE(smalltext, '\r', ''), '\n', '');
/*清楚空格+换行*/
UPDATE phome_ecms_news SET smalltext = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(smalltext, CHAR(32), ''), CHAR(34), ''),CHAR(13), ''),CHAR(10),''),CHAR(9),'');
/*清楚空格+换行+tab +*/