Converting integer to text during the select query in MySQL

Question

I'm trying to select an integer field as text but I have no idea how to do it.

The 1 represents low, the 2 represents medium, and 3 represents hi.

Omesh · Accepted Answer · 2012-08-09 07:05:24Z

3

you can do this with CASE WHEN

SELECT (CASE WHEN column = 1 THEN "low"
             WHEN column = 2 THEN "medium"
             WHEN column = 3 THEN "high"
        END) AS value
FROM table_name;

answered Aug 9, 2012 at 7:05

Omesh

29.4k6 gold badges44 silver badges51 bronze badges

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

Comments

sel · Accepted Answer · 2012-08-09 07:06:05Z

2

SELECT CASE intfield
        WHEN 1 THEN 'low'
        WHEN 2 THEN 'medium'
        WHEN 3 THEN 'hi'       
    END AS inttext
FROM table

answered Aug 9, 2012 at 7:06

sel

4,9421 gold badge18 silver badges23 bronze badges

Comments

Habib · Accepted Answer · 2012-08-09 07:06:19Z

2

Select 
CASE WHEN field = 1 then 'low' 
WHEN field = 2 then 'medium'
WHEN field = 3 then 'hi'
END as Col
from yourtable;

answered Aug 9, 2012 at 7:06

Habib

224k30 gold badges420 silver badges446 bronze badges

Collectives™ on Stack Overflow

Converting integer to text during the select query in MySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related