using SELECT and case expression

[pelegk2]

i want in the select sentence to check which month is the current date and by that to return the value.
for example if the current month is '02' then the returned values is '1' (for teling me that month 02 is in quarter 1!)
i tried to do

select * from order_header where order_id=532 and case from_unixtime(done_date,'%m') when '02' then 'feee' END;

but got an empty line!
any idea why?
thnaks in advance
peleg

[bubblenut]

You need it in the SELECT part of your query do display the result. Just as a thought, how does this kind of way of doing things look to you?

...
CASE 
WHEN FROM_UNIXTIME(done_date,'%m') BETWEEN '01' AND '06 THEN '1'
...

[pelegk2]

what u ask by

how does this kind of way of doing things look to you

[bubblenut]

I was offering you a different way of looking at the problem.

[pelegk2]

thnaks alot