title: How to export MySQL table into CSV without newlines in VARCHAR fields?
body: <p>I want to export the contents of a table into a CSV file but skip any \n or \r that might be present in the VARCHAR columns. </p>
  
  <p>I want to have one line in the CSV per row in the table. </p>
  
  <p>I've used SELECT INTO OUTFILE statement for exporting before, I don't know how to get rid of the newlines and carriage returns in the export itself. </p>
  
  <p>Any ideas?</p>