select REPLACE('1234 56',' ','') select REPLACE('1234!!56','!','') 转载于:https://www.cnblogs.com/liyunchuan/p/11200751.html