title: How to show and search for hidden characters (line feeds, etc) in SQL
body: <p>I have a large MySQL database with lots of text (like '[new line]Normal') that I want to find &amp; replace. However, I can't find it with any of the following searches, because I'm not sure what characters are used where the [new line] occurs - hence my question.</p>
  
  <pre><code>SELECT * FROM table WHERE field LIKE "%&lt;!--[if gte mso 9]&gt;&lt;xml&gt;\nNormal%";
  
  SELECT * FROM table WHERE field LIKE "%&lt;!--[if gte mso 9]&gt;&lt;xml&gt;\rNormal%";
  
  SELECT * FROM table WHERE field LIKE "%&lt;!--[if gte mso 9]&gt;&lt;xml&gt;\n\rNormal%";
  
  SELECT * FROM table WHERE field LIKE "%&lt;!--[if gte mso 9]&gt;&lt;xml&gt;\r\nNormal%";
  </code></pre>
  
  <p>Thanks for any help you can give...</p>