Finding line break and carriage return (\r\n) in MySQL
52,952
SELECT * FROM mytable WHERE mycolumn REGEXP "\r\n";
finds all records in mytable
where mycolumn
contains a \r\n
sequence.
![Display name](https://i.stack.imgur.com/gCLLd.jpg?s=256&g=1)
Author by
Display name
Updated on November 16, 2020Comments
-
Display name over 3 years
I can't seem to find any info about this on the internet (or I'm just not looking in the right direction).
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??