MySql display int as value

Question

i'd like to store into a mailbox table the folder, the message should be inside as an int. Like 0 is inbox, 1 is outbox, ...

Is there a way to make the result of the query give me back a result like 'INBOX' for the stored value of 0?

Greetings

Please provide your table structure with data and expected result and what you have tried so far — Akhil
– Akhil, Commented Aug 8, 2013 at 15:54
I would do it from the application side, like if($mailbox['Mail']['box'] = 1){ $mailboxvar = inbox } - this isn't quite what you asked for, but it might achieve the same effect — MrSynAckSter
– MrSynAckSter, Commented Aug 8, 2013 at 15:55

RiaD · Accepted Answer · 2013-08-08 16:01:34Z

1

You may store them as ENUM('INBOX', 'OUTBOX'). They will be stored as integers.

It'll be possible to write them as strings and as integer representation. They will be read as text by default.

answered Aug 8, 2013 at 16:01

RiaD

47.8k12 gold badges85 silver badges128 bronze badges

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

Comments

Akhil · Accepted Answer · 2013-08-08 16:00:48Z

0

select case message when 1 then 'INBOX' when 2 then 'OUTBOX' END from your table

Is this what you are looking for?
Refer this for more information

answered Aug 8, 2013 at 15:53

Akhil

2,60225 silver badges37 bronze badges

RiaD · Accepted Answer · 2013-08-08 16:02:46Z

0

You can use a nested IF statement:

select if(folder=0, 'Outbox', if(folder=1, 'Inbox', 'Sent')) as folder, msg_id,... from messages;

RiaD

47.8k12 gold badges85 silver badges128 bronze badges

answered Aug 8, 2013 at 15:55

Nir Alfasi

53.6k11 gold badges94 silver badges138 bronze badges