Remove line breaks before CSV export in MySQL

If you want to export the data from a MySQL table to a CSV file, often line breaks are making trouble. Because newlines are interpreted as the end of a row within the CSV file, we can quickly destroy the export data.

replace(column, CHAR(13,10), '')