如何去除mysql查询表中汉字字符后的空格

查询时汉字后面出现很多空格怎么删除。

select id,name,sex,school=replace(school,' ','') from student;

select id,name,sex,replace(school,' ','') school from student;