title: In MySql how do I export null values from an sql string in a csv file as double quotes ("")?
body: <p>I will try to keep this short and into the point.</p>
  
  <p>My goal is to export data into a CSV file using PhpMyAdmin export button.
  Some of the data from the database fields are empty and I want those empty (null) fields to be shown in the CSV file as "" (double quotes).</p>
  
  <p>I have tried using the CASE WHEN command but I am still recieving just nothing between the data. Here is the SQL code I used.</p>
  
  <pre><code> SELECT 
     CASE WHEN gift_message is null 
     THEN "\"\"" 
     ELSE gift_message 
     END 
   FROM `th_orders` 
   WHERE perfect_processed = 0;
  </code></pre>
  
  <p>This return just empty values into the csv file instead of "" as I want.
  Any help is greatly aprecciated.</p>