Mysql column string based on int

Question

I want to output a string depending on the value of int column. The query is below and language_id is an int column.

select email, language_id from tgf_mobileuser where email is not null;

What I want to do is get 'English' if language_id is 0, Japanese if language_id is 1.

Any help is greatly appreciated.

Instead of hard-coding this into the query, it would be better to have a language table that contains the language name for each ID. Then you can join with the table. — Barmar
– Barmar, Commented Sep 15, 2015 at 3:51

krivtom · Accepted Answer · 2015-09-15 03:43:31Z

6

You can use CASE statement to achieve what you want:

select email, 
    CASE language_id WHEN 0 THEN 'English'
                     WHEN 1 THEN 'Japanese'
                     ELSE 'Unknown'
    END as Language
from tgf_mobileuser 
where email is not null;

answered Sep 15, 2015 at 3:43

krivtom

25k10 gold badges53 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:14:13Z

1

I would suggest following something similar to this other post using an if clause in the select statement. 'IF' in 'SELECT' statement - choose output value based on column values

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Sep 15, 2015 at 3:43

afsheenirani

711 silver badge4 bronze badges

Collectives™ on Stack Overflow

Mysql column string based on int

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related