Can I use SQL to display custom text that is based on the column value?

Question

Is there a way to show different strings based on value found in a column?

i.e.

SELECT value FROM table;

+--------+
| value  |
+--------+
|      1 |
|      0 |
|      1 |
|      1 |
+--------+

The output I want is this:

+--------+
| value  |
+--------+
|    yes |
|     no |
|    yes |
|    yes |
+--------+

How?

Possible duplicate of [How do I perform an IF...THEN in an SQL SELECT?](https://stackoverflow.com/questions/63447/how-do-i-perform-an-if-then-in-an-sql-select) — JeffUK, May 16 '19 at 19:35

Arulkumar · Answer 1 · 2019-05-16T19:39:25.217

7

Using CASE statement you can get the expected result:

SELECT CASE WHEN value = 1 THEN 'yes' 
            WHEN value = 0 THEN 'no' 
            ELSE '' 
       END AS value
FROM testtable;

or using IF statement

SELECT IF(value = 1, 'yes', IF(value = 0, 'no', '')) AS value
FROM testtable;

edited May 16 '19 at 19:39

answered May 16 '19 at 19:23

Arulkumar

score 5 · Accepted Answer · answered May 16 '19 at 19:42

5

A fun way to do this uses elt():

select elt(value + 1, 'no', 'yes')

elt() returns the nth string based on the first argument.

answered May 16 '19 at 19:42

Gordon Linoff

2 Answers2