SyntaxFix
Write A Post
Hire A Developer
Questions
You can simply replace all \n with <br/> tag so that when page is displayed then it breaks line.
\n
<br/>
UPDATE table SET field = REPLACE(field, '\n', '<br/>')