title: Need to trim new lines from MySql result
body: <p>I am backing up data from a Magento database using MySql workbench. Here is the query I'm using:</p>
  
  <pre><code>Select FName.value AS 'FirstName' ,
  LName.value AS 'LastName' ,
  e.email,
  Address1.value AS Address1, 
  City.value AS City ,
  Province.value as Province ,
  Country.value AS 'CountryCode' ,
  Zip.value AS Zip ,
  Phone.value AS Phone
  FROM customer_entity e 
  JOIN customer_address_entity ae ON ae.parent_id = e.entity_id 
  JOIN customer_entity_int cei ON e.entity_id = cei.entity_id and cei.attribute_id=13 and cei.value=ae.entity_id 
  left JOIN customer_address_entity_varchar FName ON ae.entity_id = FName.entity_id        and FName.attribute_id = (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='firstname')
  left JOIN customer_address_entity_varchar LName ON ae.entity_id = LName.entity_id         and LName.attribute_id= (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='lastname')
  left JOIN customer_address_entity_varchar Zip ON ae.entity_id = Zip.entity_id                         and Zip.attribute_id = (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='postcode')
  left JOIN customer_address_entity_varchar City ON ae.entity_id = City.entity_id                      and City.attribute_id= (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='city')
  left JOIN customer_address_entity_varchar Phone ON ae.entity_id = Phone.entity_id           and Phone.attribute_id = (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='telephone') 
  left JOIN customer_address_entity_varchar Province ON ae.entity_id = Province.entity_id and Province.attribute_id = (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='region')
  left JOIN customer_address_entity_varchar Country ON ae.entity_id = Country.entity_id    and Country.attribute_id = (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='country_id')
  left JOIN customer_address_entity_text Address1 ON ae.entity_id = Address1.entity_id     and Address1.attribute_id = (select attribute_id from eav_attribute where entity_type_id=2 and attribute_code='street')
  </code></pre>
  
  <p>All I really need to do is strip new lines out of the Address1 field because it's breaking a CSV parser that I use.  I tried:</p>
  
  <pre><code>TRIM(\n FROM Address1.value) as Address1
  </code></pre>
  
  <p>on the fourth line of the query, but that was unsuccessful.  My knowledge of MySql is obviously limited and any help will save me a number of hours deleting new lines.  </p>