But some columns' values have linebreaks, so in my MySQL console it breaks the formatting of the table.
I know I can circumvent this by explicitly REPLACE()ing CLRF chars, but this requires me naming each column and is not very quick to type out, eg.:
SELECT id, name, REPLACE(REPLACE(description, 'r', 'r'), 'n', 'n') as 'description'... FROM tableName
The above is annoying to type, especially if i need to do this for multiple column names.
So I guess I'm asking how I can achieve the same result, but with something as easy as a SELECT *. Is there some kind of setting I can invoke at the beginning of a MySQL connection to do this for all output by default?