Skip to content

Replace newline with a space in MySQL

SELECT
  REPLACE( REPLACE( foo, CHAR(13), ''), CHAR(10), ' ') AS foo
FROM bar
;
See also  Convert column names to lowercase in Oracle SQL query results

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.