mysql删除字符串的前后的空格

 update  table  set  field = replace(replace(replace(field,char(9),''),char(10),''),char(13),'');