Query for unkown column name

[Rene Jaspers]

Oke here it goes,
i have 2 tables (exchangerate and player)
player has a column called currency
and exchangerate has columns named after those currencies
So what i would like to do is this

select
player.name,
player.currency, (like eur of usd)
exchangerate.[player.currency] as exchangerate
from
player
inner join exchangerate on ( exchangerate.date = DATE(NOW()) )
where
player.id = 1;

Giving me the following row
[name] [currency] [exchangerate]
John 'usd' 1.2345

Any help is nice!