mysql 去掉换行符 回车符

1 去掉回车+换行

update test set logiccontent=replace(logiccontent, char(13)+char(10), '');

2去掉回车

update test set logiccontent=replace(logiccontent, char(13), '');

3去掉换行

update test set logiccontent=replace(logiccontent, char(10), '');

4查询含有'%'的字串

SELECT DISTINCT key_word FROM dim_ec_ref WHERE key_word LIKE '%/%%%' ESCAPE '/'

如果觉得《mysql 去掉换行符 回车符》对你有帮助，请点赞、收藏，并留下你的观点哦！