title: Bash script outputting MySQL mediumtext one word per line
body: <p>I am writing a BASH script to output the contents of mediumtext fields from a MySQL database. It works, but my problem is every word in the mediumtext field are echoed on a separate line.</p>
  <pre><code>for i in $( mysql -u $user -p$password my_db -ss -e &quot;SELECT myticket_data.subject FROM myticket_data INNER JOIN myticket ON myticket_data.ticket_id = myticket.ticket_id WHERE myticket.status = 'open';&quot; ); do
  echo $i
  done
  </code></pre>
  <p>Instead of:</p>
  <blockquote>
  <p>I like to move it move it</p>
  </blockquote>
  <p>I get:</p>
  <blockquote>
  <p>I</p>
  <p>like</p>
  <p>to</p>
  <p>move</p>
  <p>it</p>
  <p>move</p>
  <p>it</p>
  </blockquote>
  <p>Not sure why this is happening.</p>