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