title: SQL SELECT If (a="") Then change b value
body: <p>This seems like a simple question, but I haven't been able to find an answer. I am basically trying to do this:</p>
  
  <pre><code>SELECT * FROM table1
  IF(columnA &gt; 0) BEGIN
  columnB = 'Greater than 0'
  END
  </code></pre>
  
  <p>I don't want the value to change in the table, I just want it to change in the result. ANy suggestions?</p>