MySQL if field equals X show it as Y

问题: 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 c...

可以将文章内容翻译成中文,广告屏蔽插件会导致该功能失效:

问题:

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?

回答1:

You could use CASE:

SELECT *,CASE WHEN active = -1 THEN 0
               ELSE active
        END active_2
FROM products;

or IF:

SELECT *, IF(active=-1, 0, active) AS active_2
FROM products;

发表于 2018-07-05 15:29
阅读 ( 290 )
分类：sof

部分文章转自于网络，若有侵权请联系我们删除

MySQL if field equals X show it as Y

问题:

回答1:

你可能感兴趣的文章

随机文章

相关问题

条评论

赞助商

作家榜 »

最新公告