title: Conditionally set value of column in MySQL select query
body: <p>I have a simple query in MySQL</p>
  
  <pre><code>select AGE, NAME from Members;
  </code></pre>
  
  <p>which returns,</p>
  
  <pre><code>20 ABC
  11 PQR
  21 XYZ
  16 REW
  </code></pre>
  
  <p>I need to conditionally select NAME from Members, i.e if AGE is less then 18 I need to print MINOR. So my output will be</p>
  
  <pre><code>20 ABC
  11 MINOR
  21 XYZ
  16 MINOR
  </code></pre>
  
  <p>I know I should do this programmatically, but I am dumping the output directly to a file in CSV format using</p>
  
  <pre><code> INTO OUTFILE '$random_file_name' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'
  </code></pre>
  
  <p>What are my options in MySQL query itself to achieve this?</p>