SELECT * from 2017hnhuizong1 where zwk_kaoqu='安阳'
SQL清清除特殊格式--
去除换行键和回车键
对照ASCII表
char(10)换行键
char(13)回车键
UPDATE 2017hnhuizong1 SET zwk_zw = REPLACE(REPLACE(zwk_zw, CHAR(10), ''), CHAR(13), '');
SQL清除空格
update table set col= REPLACE(col,' ','')
update 表名 set 字段名= Replace(字段名,' ','')