MySQL Workbench: Display line breaks/new line
<p>The textbook 'Murach's MySQL' featured the following query:</p>

<pre><code>SELECT CONCAT(vendor_name, CHAR(13,10), vendor_address1, CHAR(13,10), vendor_city, ', ', vendor_state, ' ', vendor_zip_code) AS mailing_address
FROM vendors
WHERE vendor_id = 1;
</code></pre>

<p>The author's output was suppose to resemble:</p>

<pre><code>US Postal Service
Attn:  Supt. Window Services
Madison, WI 53707
</code></pre>

<p>Yet the actual output looked like the following:</p>

<pre><code>US Postal Service Attn:  Supt. Window Services Madison, WI 53707
</code></pre>

<p>Also when I right click → Copy Row
/r/n appears when I go to paste the row's content in this forum's text box</p>

<pre><code>'US Postal Service\r\nAttn:  Supt. Window Services\r\nMadison, WI 53707'
</code></pre>

<p>char(10) represents line feed, char(13) represents carriage return.</p>

<p>How can I make MySQL Workbench query look like the author's output?</p>