mysql 去除空格

update nm_user set nickname=TRIM(Replace(Replace(Replace(nickname,' ',''),' ',''),' ',''))