title: MySQL if field equals X show it as Y
body: <p>I'm pretty new here and to MySQL. I tried googling the question but found only <code>SELECT column FROM table AS t</code> statements, which I believe it is not what I need.</p>
  
  <p>I have a column named "active" in a table named "products". it's optional values are <code>-1, 0, 1</code>.</p>
  
  <p>I am using <code>SELECT active FROM products</code>. It shows the table as it is but I want to make it show <code>0</code> where the value equals <code>-1</code> without changing the original value.</p>
  
  <p>Can this be done in MySQL?</p>