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 +*/