title: AWK: Mysql: like query with \newline
body: <p>I have this mysql query and I want to use it in an awk command:</p>
  
  <pre><code>select * from table where column like '%\n%';
  </code></pre>
  
  <p>this is my awk command:</p>
  
  <pre><code>mysql database -N -e "select info from table;" | awk -F ' ' '{ system("mysql -h "$1" table -N -e \"select * from table where column like '%\n%' ;\"")}'
  </code></pre>
  
  <p>Its not working. The part with '%\n%' does not work like it should. Does anyone know how to use it here?</p>
  
  <p>Thanks for help!</p>