I have a query that can return a long text field and I would like to use line breaks to break up the results, but the line break does not seem to be present in the result set in mydbr.
I do not see any line breaks when running the below in mydbr, but I do when run in MySQL Workbench:
SELECT 'some text without a line break' AS 'line';
SELECT 'some text with a return
there' AS 'line';
SELECT 'some text with a new line char \n there' AS 'line';
Is there a way to get the line breaks to show in mydbr?