MYSQL if语句问题 [英] MYSQL if statement question

问题描述

Is there any way to get the if statement to evaluate a query?

SELECT if(5>0,'EQ_Type','*') FROM EQUIPMENT;

Resulting in:
+-----------------------+
| IF(5>0,'EQ_Type','*') |
+-----------------------+
| EQ_Type               |
| EQ_Type               |
| EQ_Type               |
| EQ_Type               |
| EQ_Type               |
| EQ_Type               |
| EQ_Type               |
| EQ_Type               |
| EQ_Type               |
+-----------------------+
9 rows in set (0.00 sec)




I would like the above statement to be equivalent to the following:

SELECT 'EQ_Type' FROM EQUIPMENT;

And produce:
+--------------+
| EQ_Type      |
+--------------+
| ENGINE       |
| ENGINE       |
| ENGINE       |
| TRAILER      |
| TRAILER      |
| TRAILER      |
| WATER TENDER |
| WATER TENDER |
| WATER TENDER |
+--------------+


Thanks for any help

推荐答案

只需删除单引号。

SELECT if(5>0,EQ_Type,'*') FROM EQUIPMENT;

这篇关于MYSQL if语句问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！