title: How to replace multiple values in 1 column in mysql SELECT query using REPLACE()?
body: <p>I have a table with Boolean values (0 and 1 only) that needs to be CSV-ed to  a client. I know I can do 1 replace like this:</p>
  
  <pre><code>SELECT REPLACE(email, '%40', '@'),
         REPLACE(name,'%20', ' '),
         REPLACE(icon_clicked, 1, 'Yes') 
  FROM myTable 
  WHERE id &gt; 1000;
  </code></pre>
  
  <p>This will convert all the values of 1 to 'Yes', but how to do this in a single query for both 1 => Yes and 0 => No    so Boolean result is stored in a single column? I tried to do this:</p>
  
  <pre><code>SELECT REPLACE(email, '%40', '@'),
         REPLACE(name,'%20', ' '),
         REPLACE(icon_clicked, 1, 'Yes'),
         REPLACE(icon_clicked, 0, 'No')
  FROM myTable
  WHERE id &gt; 1000;
  </code></pre>
  
  <p>But this query created an additional column for the 'No' string replace (so final result had 4 columns, email, name, icon_clicked->yes, icon_clicked->no)</p>