title: SQL Query select col1, col2, if col3='xx' then 'yy' else col3, col4 col5??? is it posible?
body: <p>well i want to do a query as this but i dont know if it is posible</p>
  
  <pre><code>Select 
      col1, 
      col2, 
      col3, 
      if(contain(col3,'somethingx')) then 'hello' else 'world' as col4, 
      col5 
  from table1
  </code></pre>
  
  <p>In other words, I want to select </p>
  
  <pre><code>col1
  col2
  col3
  </code></pre>
  
  <p>if <code>col3</code> contains the word <code>'somethingx'</code> then I want to select <code>'hello' as col4</code></p>
  
  <p>Otherwise I want to select <code>'world' as col5</code> from my table.</p>