Search text containing a new line in MySQL
<p>I have a MySQL table that stores a large number of products. By some mistakes i added some of the product name with a new line. I need to find them. The bellow query is not listing all of the expected data.</p>

<pre><code>SELECT * FROM `products` WHERE `product_name` REGEXP "\r\n";
</code></pre>