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

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

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