MySql escaped double quotes in string when exporting to csv

I'm am having an issue with a record that contains a set of escaped double quotes inside a string when exporting my result set from MySql to a csv.

The record is showing correctly in the db:

however, when I export it to a csv, the result has the opening quote where the closing quote is supposed to be, and the closing quote at the end of the string:

.

Here is the insert statement:

INSERT INTO table_name (hh_name) VALUES ("Sam \"FakeName\" & Lisa Smith");

Is there a way to enter the data so that the csv export shows the same way as it shows up in the db?

Copyright Notice：Content Author:「rusty_shackleford」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/47947370/mysql-escaped-double-quotes-in-string-when-exporting-to-csv