Replace newline with a space in MySQL Subash Chandran 15th December 2021 Leave a Comment SELECT REPLACE( REPLACE( foo, CHAR(13), ''), CHAR(10), ' ') AS foo FROM bar ; Curly hair, very fair, please share 🙂Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Telegram (Opens in new window)Click to share on WhatsApp (Opens in new window)Click to email a link to a friend (Opens in new window) Related See also Convert column names to lowercase in Oracle SQL query results SQL .replace newline with space sql, Replace newline with a space in MySQL Change font size A Decrease font size. A Reset font size. A Increase font size.