Converting integer to string for a column

[Anitha Manickam]

can u help me to get below example

table field status holds Integer,

Status
0
1
I need to display in runtime like
Status
User
Admin.
0 - User
1 - Admin how to convert a column in Mysql Query

[Atli]

Where do you store the values associated with each number?

Typically you would store them in a separate table, like so:

+---------+     +---------+
| user    |     | role    |
+---------+     +---------+
| id (PK) |  |->| id (PK) |
| name    |  |  | name    |
| role_id |>-|  +---------+
+---------+

In which case you just use a simple JOIN:
[code=sql]SELECT user.name,
role.name AS 'role'
FROM user
LEFT JOIN role
ON user.role_id = role.id;[/code]