Replace newline with a space in MySQL
SELECT REPLACE( REPLACE( foo, CHAR(13), ''), CHAR(10), ' ') AS foo FROM bar ;
Poopcode
Code snippets | Coding interview questions with solutions | JavaScript tutorials | Python tutorials
SELECT REPLACE( REPLACE( foo, CHAR(13), ''), CHAR(10), ' ') AS foo FROM bar ;