MySQL查询去除tab、回车换行符,直接上个表格吧:
名称 | 语法 |
去除Tab 符 | replace(str,char(9),'') |
去除回车符 | replace(str,char(13),'') |
去除换行符 | replace(str,char(10),'') |
统一去除tab符、回车换行符 | replace(replace(replace(str,char(9),''), char(10), ''), char(13), '') |
MySQL查询去除tab、回车换行符,直接上个表格吧:
名称 | 语法 |
去除Tab 符 | replace(str,char(9),'') |
去除回车符 | replace(str,char(13),'') |
去除换行符 | replace(str,char(10),'') |
统一去除tab符、回车换行符 | replace(replace(replace(str,char(9),''), char(10), ''), char(13), '') |