在MySQL中查找换行符和回车符(\ r \ n) [英] Finding line break and carriage return (\r\n) in MySQL

问题描述

我似乎无法在互联网上找到任何与此相关的信息(或者我只是在寻找错误的方向).

I can't seem to find any info about this on the internet (or I'm just not looking in the right direction).

我的MySQL数据库中有一些字段，其中包含回车符和换行符\ r \ n.

I have a few fields in my MySQL database containing a carriage return and line break \r\n .

有人可以告诉我如何使用查询找到它们吗?

Is there somebody who can tell me how to find them by using a query??

推荐答案

SELECT * FROM mytable WHERE mycolumn REGEXP "\r\n";

查找mytable中的所有记录，其中mycolumn包含\r\n序列.

finds all records in mytable where mycolumn contains a \r\n sequence.

这篇关于在MySQL中查找换行符和回车符(\ r \ n)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！