Newbie query question

[wizzy_us]

Hello,

I am new to using MySQL and databases, and I was wondering if the following was possible

say I have a TABLE EXP, which has column name X , and another column Y.

which has data like
EXP
col X Y
val 1 test

Now when I query this table I want the data from coumn X but I want the column name to be Y .

To make it clearer

for example
SELECT X FROM EXP; will give me the values in COLUMN X

Like col name - X
values - 1


SELECT X AS "TEST" FROM EXP; This will give me values as
col name - TEST
values - 1

Now I want the column name to be a value for column Y
something like

col name - Y
value - 1

Is this possible ?