MySQL find Line Break

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

finds all records in mytable where mycolumn contains a sequence.