title: Search text containing a new line in MySQL
body: <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>