mysql - sql query to convert new line character to a html - Stack Overflow

First question: UPDATE exp_channel_data SET text_column = REPLACE(text_column, '\r\n', '') If it doesn't replace anything, use '\n' instead of '\r\n'. Second question: You can't do it with a SQL query, you have to fetch this data into

stackoverflow.com