Finding line break and carriage return (\r\n) in MySQL

mysql regex select carriage-return line-breaks
Display name picture Display name · Jun 12, 2012 · Viewed 44.6k times · Source

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??

Answer

Tim Pietzcker picture Tim Pietzcker · Jun 12, 2012 
SELECT * FROM mytable WHERE mycolumn REGEXP "\r\n";

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

Related questions

MySQL SELECT LIKE or REGEXP to match multiple words in one record

The field table.name contains 'Stylus Photo 2100' and with the following query SELECT `name` FROM `table` WHERE `name` LIKE '%Stylus 2100%' I get no results. Of course i would if i searched SELECT `name` FROM `table` WHERE `name` …

Read More
How to do a regular expression replace in MySQL?

I have a table with ~500k rows; varchar(255) UTF8 column filename contains a file name; I'm trying to strip out various strange characters out of the filename - thought I'd use a character class: [^a-zA-Z0-9()_ .\-] Now, is there …

Read More
How to regex in a MySQL query

I have a simple task where I need to search a record starting with string characters and a single digit after them. What I'm trying is this SELECT trecord FROM `tbl` WHERE (trecord LIKE 'ALA[d]%') And SELECT trecord …

Read More