查询字段中是否包含制表符
SELECT COLNAME,LOCATE(CHR(9),COLNAME) FROM TEST_TABLE WHERE LOCATE(CHR(9),COLNAME)>0;
替换字段中的指标符
UPDATE TEST_TABLE SET COLNAME=REPLACE(COLNAME,CHR(9),'') WHERE LOCATE(CHR(9),COLNAME)>0;
查询字段中是否包含制表符
SELECT COLNAME,LOCATE(CHR(9),COLNAME) FROM TEST_TABLE WHERE LOCATE(CHR(9),COLNAME)>0;
替换字段中的指标符
UPDATE TEST_TABLE SET COLNAME=REPLACE(COLNAME,CHR(9),'') WHERE LOCATE(CHR(9),COLNAME)>0;